AutoCall Macros Listed by Product

Base SAS

C D K L Q S T V

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

D M

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