DOCUMENTATION
Sign In

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

SAS Language Elements by Name, Product, and Category
 

Operators Listed Alphabetically

B C E I L N

Name
Syntax and Description
BETWEEN Operator
sql-expression <NOT> BETWEEN sql-expression
AND sql-expression
Selects rows where column values are within a range of values.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
COLUMNFREQ Operator
package.COLUMNFREQ(col [, rowStartIndex, rowEndIndex]);
Returns the number of distinct values in the specified column.
Product: Base SAS
Document: SAS DS2 Language Reference
COLUMNMAXLONG Operator
package.COLUMNMAXLONG(col [, rowStartIndex, rowEndIndex]);
Returns the maximum long value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Language Reference
CONTAINS Operator
sql-expression <NOT> CONTAINS sql-expression
Tests whether a string is part of a column's value.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
EXISTS Operator
<NOT> EXISTS (query-expression)
Tests if a subquery returns one or more rows.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
IN Operator
sql-expression <NOT> IN (query-expression | constant-1 <, constant-2, ...>)
Tests set membership.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
IS Operator
sql-expression IS <NOT> NULL | MISSING
Tests for a missing value.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
LIKE Operator
sql-expression <NOT> LIKE sql-expression <ESCAPE character-expression>
Tests for a matching pattern.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
_NEW_ Operator
package-variable=_NEW_ package-name ([constructor-arguments]);
Constructs an instance of a package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: Datagrid Package
package=_NEW_DATAGRID();
package=_NEW_DATAGRID(name);
Constructs an instance of a datagrid package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: FCMP Package
package-variable = _NEW_ fcmp-package-name( );
Constructs an instance of an FCMP package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: Hash Iterator Package
package-variable = _NEW_ HITER ('hash-name');
Creates an instance of a hash iterator package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: Hash Package
package-variable=_NEW_ HASH();
package-variable=_NEW_ HASH
(hashexp, 'datasource', 'ordered', 'duplicate ', 'suminc', 'multidata');
package-variable=_NEW_ HASH
( \[keys\], \[data\], [hashexp, 'datasource', 'ordered', 'duplicate ', 'suminc', 'multidata']);
package-variable=_NEW_ HASH
( \[keys\], [hashexp, {'datasource' | \{sql-text\} }, 'ordered', 'duplicate ', 'suminc', 'multidata']);
Constructs an instance of a hash package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: HTTP Package
package-variable=_NEW_ HTTP( );
Constructs an instance of an HTTP package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: JSON Package
package-variable = _NEW_ JSON( );
Constructs an instance of a JSON package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: Logger Package
package-variable = _NEW_ LOGGER([logger-name]);
Constructs an instance of a logger package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: Matrix Package
package-variable=_NEW_
MATRIX([array-name,] rows, columns)
Constructs an instance of a matrix package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: ODS Object
object-reference= _NEW_ (ODSOUT);
Creates an instance of an ODS object.
Product: Base SAS
Document: SAS Output Delivery System: Advanced Topics
_NEW_ Operator: PCRXFIND Package
package-variable = _NEW_ PCRXFIND([expression]);
Constructs an instance of a PCRXFIND package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: PCRXREPLACE Package
package-variable = _NEW_ PCRXREPLACE([expression]);
Constructs an instance of a PCRXREPLACE package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: RedisCli Package
package=_NEW_REDISCLI( );
Constructs an instance of a RedisCli package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: SQLSTMT Package
package-variable=_NEW_ SQLSTMT ('sql-text' [\[parameter-variable-list\]]);
package-variable=_NEW_ SQLSTMT ('sql-text' [, connection-string]);
package-variable=_NEW_ SQLSTMT ( );
Constructs an instance of an SQLSTMT package.
Product: Base SAS
Document: SAS DS2 Language Reference
_NEW_ Operator: TZ Package
package-variable = _NEW_ TZ([time-zone-id]);
Constructs an instance of a TZ package.
Product: Base SAS
Document: SAS DS2 Language Reference
Last updated: July 17, 2025