DOCUMENTATION
Sign In

Get access to My SAS, trials, communities and more.

SAS Language Elements by Name, Product, and Category
 

Predicates Listed Alphabetically

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: FedSQL Programming for SAS Cloud Analytic Services
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 can be selected as input or output.
Product: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
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: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
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 ( constant [, ...constant])
Tests set membership.
Product: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
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: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
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: SAS Cloud Analytic Services
Document: SAS Viya: 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: Base SAS
Document: SAS FedSQL Language Reference
IS NULL Predicate
expression IS [NOT] NULL
Tests for a null value.
Product: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
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: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
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: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
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: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
LIKE Predicate
expression [NOT] LIKE expression
Tests for a matching pattern.
Product: Base SAS
Document: SAS FedSQL Language Reference
Last updated: March 23, 2022