SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
map_product_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 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 | | Product Code | Unique product code |
11 | | PRODUCT_LEV1 | VARCHAR(200) | N | | Product Category | Product Category |
12 | | PRODUCT_LEV2 | VARCHAR(200) | N | | Product Sub-Category | Product Sub-Category |
13 | | PRODUCT_LEV3 | VARCHAR(200) | N | | Product Name | Product Name |
14
15\ingroup ddlMapping
16
17\author SAS Institute Inc.
18\date 2018
19
20*/
21CREATE TABLE &LIBREF..MAP_PRODUCT_HIERARCHY (
22 PRODUCT_CD VARCHAR(100) label='Product Code',
23 PRODUCT_LEV1 VARCHAR(200) label='Product Category',
24 PRODUCT_LEV2 VARCHAR(200) label='Product Sub-Category',
25 PRODUCT_LEV3 VARCHAR(200) label='Product Name',
26 CONSTRAINT PRIM_KEY PRIMARY KEY (PRODUCT_CD)
27);