Predicates Listed by Product

Base SAS

B D E I L

Name	Syntax and Description
BETWEEN Predicate	expression [NOT] BETWEEN expression AND expression Selects rows where column values are within a range of values. Product: Base SAS Document: SAS FedSQL Language Reference
DISTINCT Predicate	aggregate-function (DISTINCT expression); SELECT DISTINCT FROM ; Specifies that only unique rows are selected as input or output. Product: Base SAS Document: SAS FedSQL Language Reference
EXISTS Predicate	[NOT] EXISTS (select-statement) Tests whether a subquery returns one or more rows. Product: Base SAS Document: SAS FedSQL Language Reference
IN Predicate	expression [NOT] IN (select-statement | constant [, ...constant]) Tests set membership. Product: Base SAS Document: SAS FedSQL Language Reference
IS FALSE Predicate	(expression) IS [NOT] FALSE Tests for a false value. Product: Base SAS Document: SAS FedSQL Language Reference
IS MISSING Predicate	expression IS [NOT] MISSING Tests for a SAS missing value in a SAS native data store. Product: Base SAS Document: SAS FedSQL Language Reference
IS NULL Predicate	expression IS [NOT] NULL Tests for a null value. Product: Base SAS Document: SAS FedSQL Language Reference
IS TRUE Predicate	(expression) IS [NOT] TRUE Tests for a true value. Product: Base SAS Document: SAS FedSQL Language Reference
IS UNKNOWN Predicate	expression IS [NOT] UNKNOWN Tests for an unknown value. Product: Base SAS Document: SAS FedSQL Language Reference
LIKE Predicate	expression [NOT] LIKE expression Tests for a matching pattern. Product: Base SAS Document: SAS FedSQL Language Reference

SAS Cloud Analytic Services

B D E I L

Name	Syntax and Description
BETWEEN Predicate	expression [NOT] BETWEEN expression AND expression Selects rows where column values are within a range of values. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
DISTINCT Predicate	aggregate-function (DISTINCT expression); SELECT DISTINCT FROM ; Specifies that only unique rows can be selected as input or output. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
EXISTS Predicate	[NOT] EXISTS (select-statement) Tests whether a subquery returns one or more rows. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
IN Predicate	expression [NOT] IN ( constant [, ...constant]) Tests set membership. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
IS FALSE Predicate	(expression) IS [NOT] FALSE Tests for a false value. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
IS MISSING Predicate	expression IS [NOT] MISSING Tests for a SAS missing value in a SAS native data store. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
IS NULL Predicate	expression IS [NOT] NULL Tests for a null value. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
IS TRUE Predicate	(expression) IS [NOT] TRUE Tests for a true value. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
IS UNKNOWN Predicate	expression IS [NOT] UNKNOWN Tests for an unknown value. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
LIKE Predicate	expression [NOT] LIKE expression Tests for a matching pattern. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services