SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
map_geo_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 geography code to the geography hierarchy.
7
8 |PK |Variable |Type | Required? |Relationships |Label |Description |
9 |--------------|------------------|------------------|-----------|--------------|---------------------|-------------------------------------------------|
10 |![ ](pk.jpg) | GEOGRAPHY_CD | VARCHAR(32) | Y | | Geography Code | Geography code: ISO 3166-1 or ISO 3166-2 code |
11 | | GEOGRAPHY_LEV1 | VARCHAR(100) | N | | Geography Level 1 | Geography Level 1 (Continent) |
12 | | GEOGRAPHY_LEV2 | VARCHAR(100) | N | | Geography Level 2 | Geography Level 2 (Sub-division) |
13 | | GEOGRAPHY_LEV3 | VARCHAR(100) | N | | Geography Level 3 | Geography Level 3 (Country) |
14 | | GEOGRAPHY_LEV4 | VARCHAR(100) | N | | Geography Level 4 | Geography Level 4 (Region/State) |
15
16
17\ingroup ddlMapping
18
19\author SAS Institute Inc.
20\date 2018
21
22*/
23CREATE TABLE &LIBREF..MAP_GEO_HIERARCHY (
24 GEOGRAPHY_CD VARCHAR(32) label = "Geography Code",
25 GEOGRAPHY_LEV1 VARCHAR(100) label = "Geography Level 1",
26 GEOGRAPHY_LEV2 VARCHAR(100) label = "Geography Level 2",
27 GEOGRAPHY_LEV3 VARCHAR(100) label = "Geography Level 3",
28 GEOGRAPHY_LEV4 VARCHAR(100) label = "Geography Level 4",
29 CONSTRAINT PRIM_KEY PRIMARY KEY (GEOGRAPHY_CD)
30);