SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
configuration_set.sas
Go to the documentation of this file.
1/*
2 Copyright (C) 2017 SAS Institute Inc. Cary, NC, USA
3*/
4
5/**
6 \file
7 \brief Global configuration table
8
9 |PK |Variable |Type | Required? |Label |Description |
10 |--------------|---------------------------------------|------------------|-----------|--------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
11 |![ ](pk.jpg) | <b>CONFIG_SET_ID</b> | VARCHAR(32) | Y | Config Set Id | |
12 |![ ](pk.jpg) | <b>VALID_FROM_DTTM</b> | NUMERIC(8) | Y | Valid From Datetime | |
13 | | VALID_TO_DTTM | NUMERIC(8) | Y | Valid To Datetime | |
14 | | CONFIGURATION_SET_DESC | VARCHAR(64) | N | Configuration Set Description | |
15
16
17
18 \details
19
20 \ingroup ddlGlobal
21 \author SAS Institute Inc.
22 \date 2016
23*/
24CREATE TABLE &LIBREF..CONFIGURATION_SET (
25 CONFIG_SET_ID VARCHAR(32) label='Config Set Id',
26 VALID_FROM_DTTM DATE FORMAT=&DTTMFMT INFORMAT=&DTTMFMT label='Valid From Datetime',
27 VALID_TO_DTTM DATE NOT NULL FORMAT=&DTTMFMT INFORMAT=&DTTMFMT label='Valid To Datetime',
28 CONFIGURATION_SET_DESC VARCHAR(64) label='Configuration Set Description',
29 CONSTRAINT PRIM_KEY PRIMARY KEY (CONFIG_SET_ID, VALID_FROM_DTTM)
30);