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