SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
data_map_config.sas File Reference

The table DATA_MAP_CONFIG is a generic mapper used to rename/map or compute new columns. More...

Go to the source code of this file.

Detailed Description

The table DATA_MAP_CONFIG is a generic mapper used to rename/map or compute new columns.

PK Variable Type Not Null * Label Description
WORKGROUP VARCHAR(32) Y Risk Workgroup Risk Workgroup
MODELING_SYSTEM VARCHAR(150) Y Modeling System (Name and Version) Expected format: <Modeling System Name> [(<Version>)].
MAP_TYPE VARCHAR(100) Y Map Type Indicates which target table the mapping refers to.
Expected values:
- PRE_STAGE_ALLOC: Mapping performed before stage allocation.
- POST_STAGE_ALLOC: Mapping performed after stage allocation.
- DETAIL_DATA: Mapping to detail data structure.
- RPTMART_DETAIL: Mapping to the report mart detail data structure.
- RPTMART_MOVEMENTS: Mapping to the report mart movements (waterfall) data structure.
TARGET_VAR_NAME VARCHAR(32) N Target Variable Name Name of the target variable.
EXPRESSION_TXT VARCHAR(4096) N Expression text Expression. Can be any of the following:
- <Variable Name>: it will result in the variable being renamed.
- =<assignment> (i.e.: = Var1 + Var2): any valid SAS statement.
- <Blank>: This record will be ignored.
MAPPING_DESC VARCHAR(1024) N Mapping Description (Optional) Description about the purpose of the mapping rule.
TARGET_VAR_LENGTH VARCHAR(32) N Target Variable Length (Optional) Set the length of the target variable (i.e.: $32. for characters or 8. for numeric variables).
TARGET_VAR_LABEL VARCHAR(150) N Target Variable Label (Optional) Set the label for the target variable (Do not include quotes!).
TARGET_VAR_FMT VARCHAR(32) N Target Variable Format (Optional) Set the format of the target variable.

(*) indicates a not-nullable variable.

Author
SAS Institute Inc.
Date
2018

Definition in file data_map_config.sas.