SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
report_parameters.sas
Go to the documentation of this file.
1/* Copyright (C) 2017 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4\file
5\brief The table REPORT_PARAMETERS contains parameters that are specific for each report.
6
7 |PK |Variable |Type | Required? |Label |Description |
8 |--------------|------------------|------------------|-----------|---------------------------|-----------------------------------------|
9 | ![ ](pk.jpg) | REPORT_ID | VARCHAR(100) | Y | Report Id | Unique identifier of the report |
10 | ![ ](pk.jpg) | PARAMETER_NAME | VARCHAR(32) | Y | Parameter Name | Name of the report parameter |
11 | | PARAMETER_VALUE | VARCHAR(10000) | N | Parameter Value | Value for the report parameter |
12 | | PARAMETER_DESC | VARCHAR(256) | N | Parameter Description | Description of the report parameter |
13
14\details
15
16
17\ingroup ddlStaticReporting
18\author SAS Institute Inc.
19\date 2019
20*/
21
22CREATE TABLE &LIBREF..REPORT_PARAMETERS (
23 REPORT_ID VARCHAR(100) NOT NULL label = 'Report Id',
24 PARAMETER_NAME VARCHAR(32) NOT NULL label = 'Parameter Name',
25 PARAMETER_VALUE VARCHAR(10000) label = 'Parameter Value',
26 PARAMETER_DESC VARCHAR(256) label = 'Parameter Description',
27 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORT_ID, PARAMETER_NAME)
28);