AutoCall Macros Listed by Product
Base SAS
|
Name
|
Syntax and Description
|
|---|---|
|
%CMPRES
(text | text-expression)
%QCMPRES
(text | text-expression)
Compress multiple blanks and remove leading and
trailing blanks.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%COMPSTOR(PATHNAME=SAS-data-library)
Compiles macros and stores them in a catalog in
a permanent SAS library.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%DATATYP
(text | text-expression)
Returns the data type of a value.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%KLOWCASE (text | text expression)
Change uppercase characters to lowercase.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
| |
|
%KTRIM (text | text expression)
Trim trailing blanks.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
| |
|
%KVERIFY(source, excerpt)
Returns the position of the first character unique
to an expression.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%KVERIFY (source, excerpt)
Returns the position of the first character unique
to an expression.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
| |
|
%LEFT(text | text-expression)
Left-align an argument by removing leading blanks.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%LOWCASE
text | text-expression()
Change uppercase characters to lowercase.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%QCMPRES (text | text-expression)
Compresses multiple blanks, removes leading and
trailing blanks, and returns a result that masks special characters
and mnemonic operators.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%QKLOWCAS (text | text expression)
Change uppercase characters to lowercase.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
| |
|
%QKTRIM (text | text expression)
Trim trailing blanks.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
| |
|
%QLEFT
text | text-expression()
Left-aligns an argument by removing leading blanks
and returns a result that masks special characters and mnemonic operators.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%QLOWCASE(text | text-expression)
Changes uppercase characters to lowercase and returns
a result that masks special characters and mnemonic operators.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%QTRIM (text | text-expression)
Trims trailing blanks and returns a result that
masks special characters and mnemonic operators.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%SYSRC(character-string)
Returns a value corresponding to an error condition.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%TRIM(text | text-expression)
Trim trailing blanks.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
| |
|
%VERIFY(source, excerpt)
Returns the position of the first character unique
to an expression.
Product: Base SAS
Document: SAS Macro Language Reference for SAS Viya Workbench
|
SAS Data Quality Server
|
Name
|
Syntax and Description
|
|---|---|
|
%DQLOAD(DQSETUPLOC="quality-knowledge-base-name",
DQLOCALE=(locale <
locale2 locale3...>), <DQINFO=0|1>);
Sets system option values and loads locales into
memory.
Product: SAS Data Quality Server
Document: SAS Data Quality Reference for SAS Viya Workbench
| |
|
%DQPUTLOC (locale);
Displays in the SAS log current information about
a specified locale.
Product: SAS Data Quality Server
Document: SAS Data Quality Reference for SAS Viya Workbench
| |
|
%DQSURVR(inTable="libref.tablename",
outTable="libref.out_data_tablename", clusterColumn="cluster_ID", rowRule1=(operator, column, column or value, or (value1, value2,...)), rowRule1BoolOperator=AND|OR, rowRule2=(operator, column, column or value or (value1, value2,...)), firstColumnRule1=(operator, column, column or value or (value1, value2,...)), firstColumnRule1BoolOperator=AND|OR, firstColumnRule2=(operator, column, column or value or (value1, value2,...)), firstColumnRuleAppliedCols=(column1, column2,...), secondColumnRule1=(operator, column, column or value or (value1, value2,...)), secondColumnRule1BoolOperator=AND|OR, secondColumnRule2=(operator, column, column or value or (value1, value2,...)), secondColumnRuleAppliedCols=(column1, column2,...), keepDuplicates=0|1, survivingRecordID=, generateDistinctSurvivor=0|1, usePkAsDupFlag=0|1, pkCol=, ); Performs Entity Resolution Survivorship as an autocall macro and extracts the
surviving record from clustered data based on user-specified criteria.
Product: SAS Data Quality Server
Document: SAS Data Quality Reference for SAS Viya Workbench
| |
|
%DQUNLOAD;
Unloads all locales to increase the amount of free
memory.
Product: SAS Data Quality Server
Document: SAS Data Quality Reference for SAS Viya Workbench
| |
|
Macro Resources
Product: SAS Data Quality Server
Document: SAS Data Quality Reference for SAS Viya Workbench
|
SAS/GRAPH
|
Name
|
Syntax and Description
|
|---|---|
|
%SHORTCUT (NAME=new-name <PROTOTYPE=existing-name>
<DESCRIPTION=description> <LIBREF=libref> <REGISTRY=SASUSER | SASHELP>) Creates a shortcut device that is linked to the
existing Universal Printer of the same name, or defines a new Universal
Printer and shortcut device and links the device to the Universal
Printer.
Product: SAS/GRAPH
Document: SAS/GRAPH: Reference for SAS Viya Workbench
|
Last updated: September 24, 2026