The custom step enables SAS Studio users to import and activate a lookup table for SAS Intelligent Decisioning (SID) from input data, using DCM_IMPORT_LOOKUP macro. The macro DCM_IMPORT_LOOKUP (part of SID) uses the lookup table name and folder path name to determine whether a lookup table already exists. If the lookup table already exists, then it is updated. If either the path name or lookup table name does not exist, it is created.
- From input table, select a column for the lookup table keys (required).
- From input table, select a column for the lookup table values (required).
- Define a name for your lookup table (required).
- Define a description for your lookup table (optional).
- Define a location on the sas content for your lookup table (required). --> the location path can be browsed or defined by a string or a macro variable.
- Activate or not the lookup table. By default, this option is checked.
- Tested on Viya version Stable 2024.12.
- Requires : SAS® Intelligent Decisioning 5.4 or higher.
- Uses : DCM_IMPORT_LOOKUP macro (https://go.documentation.sas.com/doc/en/edmcdc/default/edmmacro/n0ni2e3h31k5x3n1v1w4e46z7rnh.htm)
- Uses : /folders/paths REST API (https://developer.sas.com/rest-apis/folders/findByPath)
- Can be used in a flow or in stand alone.
- Require an input data set with valid columns for keys and values.
- Version 1.0 (07FEB2025)
- Initial version