SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
dq_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 DQ_CONFIG contains configuration parameters for Data Quality execution.
6
7 |PK |Variable |Type | Required? |Label |Description |
8 |--------------|------------------------|------------------|-----------|---------------------------|-------------------------------------------------------------|
9 |![ ](pk.jpg) | <b>CONFIG_NAME</b> | VARCHAR(40) | Y | Config Name | Parameter Name: it must be valid SAS Macro variable name |
10 | | CONFIG_VALUE | VARCHAR(256) | N | Config Value | Value for the parameter |
11 | | CONFIG_VALUE_DESC | VARCHAR(150) | N | Config Value Description | Parameter description |
12
13
14Data Example:
15
16 | CONFIG_NAME | CONFIG_VALUE | CONFIG_VALUE_DESC |
17 |---------------|--------------|-------------------------------------------------------|
18 | RULE_ID_LIST | 10001 10002 | Space separated list of RGF Rule identifiers |
19 | TABLE_ID_LIST | 10010 10014 | Space separated list of RGF Analysis Data identifiers |
20
21\ingroup ddlStaticDQ
22\author SAS Institute Inc.
23\date 2018
24*/
25
26CREATE TABLE &LIBREF..DQ_CONFIG (
27 CONFIG_NAME VARCHAR(40) label = 'Config Name',
28 CONFIG_VALUE VARCHAR(10000) label = 'Config Value',
29 CONFIG_VALUE_DESC VARCHAR(150) label = 'Config Value Description',
30 CONSTRAINT PRIM_KEY PRIMARY KEY (CONFIG_NAME)
31);