SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
data_map_config.sas
Go to the documentation of this file.
1/*
2 Copyright (C) 2015 SAS Institute Inc. Cary, NC, USA
3*/
4
5/**
6 \file
7 \brief The table DATA_MAP_CONFIG is a generic mapper used to rename/map or compute new columns.
8
9 |PK |Variable |Type |Not Null * |Label |Description |
10 |---|--------------------------|------------------|-----------|-------------------------------------|------------------------------------------------------------------------------------------------------------------------------------|
11 | | WORKGROUP | VARCHAR(32) | Y | Risk Workgroup | Risk Workgroup |
12 | | MODELING_SYSTEM | VARCHAR(150) | Y | Modeling System (Name and Version) | Expected format: <i>&lt;Modeling System Name&gt; <b>[</b>(&lt;Version&gt;)<b>]</b></i>. |
13 | | MAP_TYPE | VARCHAR(100) | Y | Map Type | Indicates which target table the mapping refers to. <br> Expected values: <br> - PRE_STAGE_ALLOC: Mapping performed before stage allocation. <br> - POST_STAGE_ALLOC: Mapping performed after stage allocation. <br> - DETAIL_DATA: Mapping to detail data structure. <br> - RPTMART_DETAIL: Mapping to the report mart detail data structure. <br> - RPTMART_MOVEMENTS: Mapping to the report mart movements (waterfall) data structure. |
14 | | TARGET_VAR_NAME | VARCHAR(32) | N | Target Variable Name | Name of the target variable. |
15 | | EXPRESSION_TXT | VARCHAR(4096) | N | Expression text | Expression. Can be any of the following: <br> - &lt;Variable Name&gt;: it will result in the variable being renamed. <br> - =&lt;assignment&gt; (i.e.: = Var1 + Var2): any valid SAS statement. <br> - &lt;Blank&gt;: This record will be ignored. |
16 | | MAPPING_DESC | VARCHAR(1024) | N | Mapping Description | (Optional) Description about the purpose of the mapping rule. |
17 | | 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). |
18 | | TARGET_VAR_LABEL | VARCHAR(150) | N | Target Variable Label | (Optional) Set the label for the target variable (Do not include quotes!). |
19 | | TARGET_VAR_FMT | VARCHAR(32) | N | Target Variable Format | (Optional) Set the format of the target variable. |
20 (*) indicates a not-nullable variable.
21
22
23 \details
24
25 \ingroup ddlStaticAnalytics
26 \author SAS Institute Inc.
27 \date 2018
28*/
29CREATE TABLE &LIBREF..DATA_MAP_CONFIG (
30 WORKGROUP VARCHAR(32) label='Risk Workgroup',
31 MODELING_SYSTEM VARCHAR(150) label='Modeling System (Name and Version)',
32 MAP_TYPE VARCHAR(100) label='Map Type',
33 TARGET_VAR_NAME VARCHAR(32) label='Target Variable Name',
34 EXPRESSION_TXT VARCHAR(4096) label='Expression',
35 MAPPING_DESC VARCHAR(1024) label='Mapping Description ',
36 TARGET_VAR_LENGTH VARCHAR(32) label='Target Variable Length',
37 TARGET_VAR_LABEL VARCHAR(150) label='Target Variable Label',
38 TARGET_VAR_FMT VARCHAR(32) label='Target Variable Format'
39 );