SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
map_lob_hierarchy.sas
Go to the documentation of this file.
1/* Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4\file
5
6\brief Maps Line of Business codes to the lowest level of the Line of Business hierarchy.
7
8 |PK |Variable |Type | Required? |Relationships |Label |Description |
9 |--------------|------------------|------------------|-----------|--------------|----------------------------|----------------------------|
10 |![ ](pk.jpg) | <b>LOB_ID</b> | VARCHAR(100) | Y | | Line of Business Id | Line of Business Id |
11 | | LOB_LEV1 | VARCHAR(200) | N | | Line of Business Level 1 | Line of Business Level 1 |
12 | | LOB_LEV2 | VARCHAR(200) | N | | Line of Business Level 2 | Line of Business Level 2 |
13 | | LOB_LEV3 | VARCHAR(200) | N | | Line of Business Level 3 | Line of Business Level 3 |
14
15\ingroup ddlMapping
16
17\author SAS Institute Inc.
18\date 2018
19
20*/
21CREATE TABLE &LIBREF..MAP_LOB_HIERARCHY (
22 LOB_ID VARCHAR(100) label = 'Line of Business Id',
23 LOB_LEV1 VARCHAR(200) label = 'Line of Business Level 1',
24 LOB_LEV2 VARCHAR(200) label = 'Line of Business Level 2',
25 LOB_LEV3 VARCHAR(200) label = 'Line of Business Level 3',
26 CONSTRAINT PRIM_KEY PRIMARY KEY (LOB_ID)
27);