SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
map_regulatory_product_hierarchy.sas
Go to the documentation of this file.
1/* Copyright (C) 2020 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4\file
5
6\brief Maps the product code to the Product hierarchy.
7
8 |PK |Variable |Type | Required? |Relationships |Label |Description |
9 |--------------|---------------------------|------------------|-----------|--------------|----------------------------------|-----------------------------------|
10 |![ ](pk.jpg) | PRODUCT_CD | VARCHAR(100) | Y | | Regulatory Product Code | Unique regulatory product code |
11 | | REGULARTORY_PRODUCT_LEV1 | VARCHAR(200) | N | | FR Y-14 Category 1 | FR Y-14 Category 1 |
12 | | REGULARTORY_PRODUCT_LEV2 | VARCHAR(200) | N | | FR Y-14 Category 2 | FR Y-14 Category 2 |
13 | | REGULARTORY_PRODUCT_LEV3 | VARCHAR(200) | N | | FR Y-14 Category 3 | FR Y-14 Category 3 |
14 | | REGULARTORY_PRODUCT_LEV4 | VARCHAR(200) | N | | FR Y-14 Category 4 | FR Y-14 Category 4 |
15
16\ingroup ddlMapping
17
18\author SAS Institute Inc.
19\date 2020
20
21*/
22CREATE TABLE &LIBREF..MAP_REGULATORY_PRODUCT_HIERARCHY (
23 PRODUCT_CD VARCHAR(100) label='Regulatory Product Code',
24 REGULATORY_PRODUCT_LEV1 VARCHAR(200) label='FR Y-14 Category 1',
25 REGULATORY_PRODUCT_LEV2 VARCHAR(200) label='FR Y-14 Category 2',
26 REGULATORY_PRODUCT_LEV3 VARCHAR(200) label='FR Y-14 Category 3',
27 REGULATORY_PRODUCT_LEV4 VARCHAR(200) label='FR Y-14 Category 4',
28 CONSTRAINT PRIM_KEY PRIMARY KEY (PRODUCT_CD)
29);