DOCUMENTATION
Sign In

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

 

Operators Listed by Product

Base SAS
Base SAS

Base SAS

C N

Name
Syntax and Description
COLUMNFREQ Operator
package.COLUMNFREQ(col <, rowStartIndex, rowEndIndex>);
Returns the number of distinct values in the specified column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
COLUMNMAXLONG Operator
package.COLUMNMAXLONG(col <, rowStartIndex, rowEndIndex>);
Returns the maximum long value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_NEW_ Operator
package-variable=_NEW_ package-name (<constructor-arguments>);
Constructs an instance of a package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_NEW_ Operator: Datagrid Package
package=_NEW_DATAGRID();
package=_NEW_DATAGRID(name);
Constructs an instance of a datagrid package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_NEW_ Operator: FCMP Package
package-variable = _NEW_ fcmp-package-name( );
Constructs an instance of an FCMP package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_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 Reference for SAS Viya Workbench
_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 Reference for SAS Viya Workbench
_NEW_ Operator: HTTP Package
package-variable=_NEW_ HTTP( );
Constructs an instance of an HTTP package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_NEW_ Operator: JSON Package
package-variable = _NEW_ JSON( );
Constructs an instance of a JSON package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_NEW_ Operator: Logger Package
package-variable = _NEW_ LOGGER(<logger-name>);
Constructs an instance of a logger package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_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 Reference for SAS Viya Workbench
_NEW_ Operator: ODS Object
object-reference= _NEW_ (ODSOUT);
Creates an instance of an ODS object.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
_NEW_ Operator: PCRXFIND Package
package-variable = _NEW_ PCRXFIND(<expression>);
Constructs an instance of a PCRXFIND package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_NEW_ Operator: PCRXREPLACE Package
package-variable = _NEW_ PCRXREPLACE(<expression>);
Constructs an instance of a PCRXREPLACE package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_NEW_ Operator: RedisCli Package
package=_NEW_REDISCLI( );
Constructs an instance of a RedisCli package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_NEW_ Operator: SQLSTMT Package
package-variable=_NEW_ SQLSTMT ('sql-text' <\[parameter-variable-list\]>);
package-variable=_NEW_ SQLSTMT ( );
Constructs an instance of an SQLSTMT package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
_NEW_ Operator: TZ Package
package-variable = _NEW_ TZ(<time-zone-id>);
Constructs an instance of a TZ package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench

Base SAS

B C E I L

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 Viya Workbench: SQL Procedure User’s Guide
CONTAINS Operator
sql-expression <NOT> CONTAINS sql-expression
Tests whether a string is part of a column's value.
Product: Base SAS
Document: SAS Viya Workbench: 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 Viya Workbench: 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 Viya Workbench: SQL Procedure User’s Guide
IS Operator
sql-expression IS <NOT> NULL | MISSING
Tests for a missing value.
Product: Base SAS
Document: SAS Viya Workbench: 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 Viya Workbench: SQL Procedure User’s Guide
Last updated: September 24, 2026