Macros Listed by Product

Base SAS

C D T

Name
Syntax and Description
%COPY_TO_NEW_ENCODING(from_dsname, to_dsname, new_encoding)
Creates a new version of a data set with a specified encoding.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
%COPY_TO_UTF8(from_dsname, to_dsname);
Creates a new version of a data set in UTF-8 encoding.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
%DS2CSV(argument-1=value-1, argument-2=value-2 <,argument-3=value-3 ...>)
Converts SAS data sets to comma-separated value (CSV) files.
Product: Base SAS
Document: Base SAS Utilities: Reference
%TSLIT (literal text)
Overrides the need for double quotation marks around literal text and puts single quotation marks around the input value.
Product: Base SAS
Document: Base SAS Utilities: Reference

SAS Intelligent Decisioning

Name
Syntax and Description
%DCM_BUILD_SUBJECTCONTACT_SIM_ABT (NEWABT=<libref.>table,
ABTATTRIBUTES=<libref.>table,
OBJECTVARIABLES=<libref.>table,
SUBJECTCONTACT=<libref.>table
<, optional-arguments>
)
Reads the output tables that were produced by the %DCM_GET_SUBJECTCONTACT_HISTORY macro and builds an analytical base table (ABT) by using the data in those output tables. It also builds an attribute table that contains the values of each attribute that is in the decision’s treatments. You can use the ABT as input for a modeling or reporting process in order to discover which attributes and variables are driving the decision process.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_CALCULATE_SAMPLE_SIZE (ESTCONVRATE=conversion-rate,
SAMPLESIZE=<sample-size>
<, optional-arguments>
)
Performs a sample size analysis for tests of two independent proportions. You can use this macro to determine the sample size for a branch of an A/B test node.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_CONVERT_DATAGRID_TO_TABLE (
GRIDCOL=data-grid-column-name,
GRIDTABLE=input-table-base-name,
<FIXEDMETADATA=YES | NO,>
<MERGE=YES | NO, >
<OUTLIB=libref,>
<PROMOTE=YES | NO>
)
Converts each data grid to a separate table, and if the MERGE option is specified, merges the separate tables into a single output table.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
%DCM_CREATE_PUBLISH_VALIDATION (sourceURI=/decisions/flows/decision-or rule-set-ID,
DESTINATIONTYPE=destination-type,
PUBLISHNAME=published-name,
SCOREDEFINITIONNAME=definition-name,
VERSION=version-ID
<, optional-arguments>
)
Creates a publishing validation test for a published decision or rule set.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_DATAGRID_INTERFACE()
Makes the data grid functions available in .
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
%DCM_DATAGRID_JSON_TO_TABLE (
JSONFILE=data-grid-JSON-file,
OUTPUTTABLE=<libref.>table,
<PROMOTE=YES | NO>
)
Creates a data grid from the JavaScript Object Notation (JSON) string that is specified in the input file, and writes the data grid to the specified output table.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
%DCM_DECISION_NODES_COUNTS (URI=decision-URI,
PATHNODESTABLE=<libref.>table,
FREQNODESTABLE=<libref.>table,
OUTPUTTABLE=<libref.>table
<, optional-arguments>
)
Reads the tables that were produced by the %DCM_DECISION_PATH_FREQUENCY and %DCM_DECISION_PATH_NODES macros and produces a table that documents how many times each node in the decision was traversed.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_DECISION_PATH_FREQUENCY (URI=decision-URI,
INPUTTABLE=<libref.>table,
OUTPUTTABLE=<libref.>table
<, optional-arguments>
)
Reads the output table that was produced by a rule set or decision, and produces a table that contains the unique set of paths that were traversed to produce the output and the number of times each path was taken.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_DECISION_PATH_NODES (URI=decision-URI,
INPUTTABLE=<libref.>table,
OUTPUTTABLE=<libref.>table
<, optional-arguments>
)
Reads the table that was produced by the %DCM_DECISION_PATH_FREQUENCY macro, and produces an output table that documents the structure of the decision. The output table shows the order and depth of the nodes that were traversed when the decision executed.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_EXECUTE_DECISION (URI=decision-revision-URI,
INPUTTABLE=<libref.>table,
OUTPUTTABLE=<libref.>table
<, optional-arguments>
)
Generates and executes code for the specified decision version.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_EXECUTE_RULESET (URI=rule-set-revision-URI,
INPUTTABLE=<libref.>table,
OUTPUTTABLE=<libref.>table
<, optional-arguments>
)
Generates and executes code for the specified rule set version.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_EXECUTE_TREATMENT_GROUP(URI=treatment_group_revision_URI,
INPUTTABLE=<libref.>table,
OUTPUTTABLE=<libref.>table
<, optional-arguments>
)
Generates and executes the code for the specified treatment group version.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_EXPORT_LOOKUP (CSV=fileref<, optional-arguments>)
Exports lookup tables and value lists to a CSV file. You can modify the CSV file and use it as input to the %DCM_IMPORT_LOOKUP macro.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_EXPORT_RULESET (CSV=fileref<, optional-arguments>)
Exports SAS Intelligent Decisioning rule sets into a CSV file. You can modify the CSV file and use it as input to the %DCM_IMPORT_RULESET macro.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_GET_REVISIONS (TYPE=RULESET | DECISION<, optional-arguments>)
Gets the metadata for all versions of the specified object type that match the specified filter and writes the information to the specified output table.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_GET_SUBJECTCONTACT_HISTORY (<, optional-arguments>)
Retrieves subject contact history information for the specified decision from the subjectContact microservice. It creates several output tables that the %DCM_BUILD_SUBJECTCONTACT_SIM_ABT macro can use to build an analytical base table (ABT) . The information that is retrieved depends on the information that is tracked with record contacts nodes.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_GET_TOKEN(USER=user_ID,
PW=password,
TOKENNAME=token_name
<, SERVERNM=http-proxy-host-name<:port>>
)
Generates an authentication token to be used with SAS Intelligent Decisioning macros.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_IMPORT_LOOKUP (CSV=fileref<, optional-arguments>)
Imports lookup tables or value lists from the specified CSV file into SAS Intelligent Decisioning.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_IMPORT_RULE_FLOW (RULEFLOW_CSV=fileref,
VOCAB_CSV=fileref<, optional-arguments>)
Imports simple rule flows that were exported from on SAS 9.4 or from on SAS 9.4 into SAS Intelligent Decisioning on Viya 4. The rule flows are imported as decisions.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_IMPORT_RULESET (CSV=fileref<, optional-arguments>)
%DCM_IMPORT_RULESET (LEGACY_RULE_CSV=fileref,
VOCABULARY_CSV=fileref<, optional-arguments>)
Imports rule sets from the specified CSV file into SAS Intelligent Decisioning.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_JSON_TO_DATAGRID (
JSONFILE=standard-JSON-file-name,
GRIDFILE=data-grid-file-name,
CONVERTTYYPE=JSONTOGRID | GRIDTOJSON
<RETRIEVE_NEST=YES | NO, >
<GRIDTABLE=table-name,>
<PROMOTE=YES | NO>
)
Converts a standard JSON string to a data grid JSON string, or vice versa.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
%DCM_MERGESERIALIZEDGRIDS (
MERGETABLE=table_name,
MERGEKEY=merged_table_key,
OUTPUTTABLE=results_table,
GRIDTABLES=data_grid1 < data_grid2>...,
GRIDMERGEKEYS=data_grid_key1 < data_grid_key2>...,
GRIDCOLUMNS=data_grid_column1 < data_grid_column2>...,
<PROMOTE=YES | NO>
)
Merges tables that contain data grids that have been serialized with the %DCM_SERIALIZEGRIDS macro with a table that contains scalar data.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
%DCM_PUBLISH_DECISION (URI=/decisions/flows/decision-ID/revisions/revision-ID,
DESTINATION=publishing-destination,
PUBLISHNM=published-name
<, optional-arguments>
)
Publishes the specified decision revision.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_RULEFIRE_DETAIL (URI=URI,
INPUTTABLE=<libref.>table,
OUTPUTTABLE=<libref.>table
<, optional-arguments>
)
Reads the output table that was produced by running a rule set or decision or by running the %DCM_GET_SUBJECTCONTACT_HISTORY macro and generates a rule-fired detail table.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_RULEFIRE_SUMMARY (URI=URI,
INPUTTABLE=<libref.>table,
OUTPUTTABLE=<libref.>table
<, optional-arguments>
)
Reads the output table that was produced by the %DCM_RULEFIRE_DETAIL macro and generates a rule-fired summary table for the specified rule set or decision.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_SERIALIZEGRID (
GRIDCOLNAME=data_grid_column_name,
GRIDSOURCETABLE=table_name,
OUTPUTTABLE=<libref.>table,
<CLASSVARS=class_variable1< class_variable2...>,>
<GRIDCOLS=column1< column2...>,>
<GRIDCOLLEN=length,>
<PROMOTE=YES | NO>
)
Creates a table in which one of the columns contains a JSON string that represents a data grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
%DCM_UPDATE_RULESET_DATATYPE (ID=ID<, optional-arguments>)
Updates the data types of the variables for the specified rule set.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
%DCM_UPDATE_SUBJECTCONTACT (SUBJECTCONTACTID=contact-ID
<,optional-arguments>)
or
%DCM_UPDATE_SUBJECTCONTACT (RESPONSETRACKINGCODE=tracking-code
<,optional-arguments>)
%DCM_UPDATE_SUBJECTCONTACT (SUBJECTCONTACTS=<libref..>table
<,optional-arguments>)
Updates records in the subject contact history database with data about treatments that were offered to subjects and the subjects’ responses to those treatments.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Macro Guide
Last updated: September 16, 2026