SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
bsp_data_config.sas
Go to the documentation of this file.
1/* Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4\file
5\brief The table BSP_DATA_CONFIG contains configuration for the retrieval of any analysis data from the data repository.
6
7 |PK |Variable |Type | Required? |Label |Description |
8 |--------------|---------------------|------------------|-----------|---------------------------|--------------------------------------------------------------------------------------------------------------------|
9 | ![ ](pk.jpg) | SOURCE_DATA_NAME | VARCHAR(32) | Y | Source Data Name | Name of the output table being the result of the extraction |
10 | | ANALYSIS_DATA_KEY | VARCHAR(32) | Y | Report Name | Key of the Analysis Data to retrieve |
11 | | SOURCE_DATA_VERSION | VARCHAR(32) | Y | Source Data Version | Version of the output table being the result of the extraction |
12 | | SCENARIO_NAME | VARCHAR(512) | Y | Scenario Name | Scenario name |
13
14\details
15
16
17\ingroup ddlStaticReporting
18\author SAS Institute Inc.
19\date 2018
20*/
21
22CREATE TABLE &LIBREF..BAL_SHEET_PROJ_DATA_CONFIG (
23 SOURCE_DATA_NAME VARCHAR(32) label = 'Source Data Name',
24 ANALYSIS_DATA_KEY VARCHAR(32) label = 'Analysis Data Key',
25 SOURCE_DATA_VERSION VARCHAR(32) label = 'Source Data Version',
26 SCENARIO_NAME VARCHAR(512) label = 'Scenario Name',
27 CONSTRAINT PRIM_KEY PRIMARY KEY (SOURCE_DATA_NAME)
28);