AutoCall Macros Listed Alphabetically
|
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
| |
|
%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
| |
|
%DATATYP
(text | text-expression)
Returns the data type of a value.
Product: Base SAS
Document: SAS Macro Language: Reference
| |
|
%DQCLRTNG(inTable=libref.inData,
outTable=libref.outData, primaryKeyVar=CUSTOMER_ID, matchRule1=column1$column2$column3, matchRule2=column4$column5, matchRule3=column6, matchRule4=column7, matchRule5=column8, clusterIDVar=CLUSTER_ID, promoteToCas=0|1, saveToDisk=0|1, fileFormat= ); Clusters records in the input table.
Product: SAS Data Quality Server
Document: SAS Data Quality: Language Reference
| |
|
%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: Language Reference
| |
|
%DQOPTNET(inTable=libref.inData,
primaryKeyVar=inKeyVarName, matchRule1=var1$var2, matchRule2=var1$var3, matchRule3=var7, clusterIDVar=outClustIDColName, outTable=libref.outData, promoteToCas=0|1, saveToDisk=0|1, replaceOnDisk=0|1, fileFormat=); ; Provides a common framework to perform clustering.
Product: SAS Data Quality Server
Document: SAS Data Quality: Language Reference
| |
|
%DQPUTLOC (locale);
Displays in the SAS log current information about
a specified locale.
Product: SAS Data Quality Server
Document: SAS Data Quality: Language Reference
| |
|
%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=, promoteToCas=0|1); 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: Language Reference
| |
|
%DQUNLOAD;
Unloads all locales to increase the amount of free
memory.
Product: SAS Data Quality Server
Document: SAS Data Quality: Language Reference
| |
|
%KLOWCASE (text | text expression)
Change uppercase characters to lowercase.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
| |
|
%KTRIM (text | text expression)
Trim trailing blanks.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
| |
|
%KVERIFY(source, excerpt)
Returns the position of the first character unique
to an expression.
Product: Base SAS
Document: SAS Macro Language: Reference
| |
|
%KVERIFY (source, excerpt)
Returns the position of the first character unique
to an expression.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
| |
|
%LEFT(text | text-expression)
Left-align an argument by removing leading blanks.
Product: Base SAS
Document: SAS Macro Language: Reference
| |
|
%LOC2XPT (FILESPEC=filespec , <LIBREF=libref>, <MEMLIST =memlist>,
<FORMAT=format>) Identifies whether the data set you are reading
in has any extended data set features and creates a V8 transport file
or a V5 transport file accordingly.
Product: Base SAS
Document: Moving and Accessing SAS Files
| |
|
%LOG4SAS( )
Initializes the logging environment to use autocall
macros.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
%LOG4SAS_APPENDER(name, "FileRefAppender"
<, '<FILEREF=fileref> <PATTERN="pattern"> <THRESHOLD=threshold>'> ) Defines an appender.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
%LOG4SAS_DEBUG(logger-name, message)
Logs a DEBUG message if the specified logger accepts DEBUG
messages.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
%LOG4SAS_ERROR(logger-name, message)
Logs an ERROR message if the specified logger accepts ERROR
messages.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
%LOG4SAS_FATAL(logger-name, message)
Logs a FATAL message if the specified logger accepts FATAL
messages.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
%LOG4SAS_INFO(logger-name, message)
Logs an INFO message if the specified logger accepts INFO
messages.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
%LOG4SAS_LOGGER(name
<, "<ADDITIVITY=TRUE
| FALSE>
<APPENDER-REF=(appender-list)> <LEVEL=level>">) Defines a logger.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
%LOG4SAS_TRACE(logger-name, message)
Logs a TRACE message if the specified logger accepts TRACE
messages.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
%LOG4SAS_WARN(logger-name, message)
Logs a WARN message if the specified logger accepts WARN
messages.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
%LOWCASE
text | text-expression()
Change uppercase characters to lowercase.
Product: Base SAS
Document: SAS Macro Language: Reference
| |
|
Macro Resources
Product: SAS Data Quality Server
Document: SAS Data Quality: Language Reference
| |
|
%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
| |
|
%QKLOWCAS (text | text expression)
Change uppercase characters to lowercase.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
| |
|
%QKTRIM (text | text expression)
Trim trailing blanks.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
| |
|
%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
| |
|
%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
| |
|
%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
| |
|
%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
| |
|
%SYSRC(character-string)
Returns a value corresponding to an error condition.
Product: Base SAS
Document: SAS Macro Language: Reference
| |
|
%TRIM(text | text-expression)
Trim trailing blanks.
Product: Base SAS
Document: SAS Macro Language: Reference
| |
|
%UDFSEL (SAS-library-name);
Generates a SELECT statement for the unique non-intrinsic
user-defined formats that are referenced in the data sets in a single
SAS library.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User-Defined Formats
| |
|
%VERIFY(source, excerpt)
Returns the position of the first character unique
to an expression.
Product: Base SAS
Document: SAS Macro Language: Reference
| |
|
%XPT2LOC (FILESPEC= filespec, <LIBREF=libref>, <MEMLIST =memlist> )
Can convert older V5 transport files and v8/v9 transport
file format back into SAS data sets.
Product: Base SAS
Document: Moving and Accessing SAS Files
|
Last updated: September 16, 2026