SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
execution_config.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 EXECUTION_CONFIG contains runtime execution configuration.
6
7 |PK |Variable |Type | Required? |Label |Description |
8 |--------------|------------------|------------------|-----------|---------------------------|--------------------------------------------------------------------------------------------------------------------|
9 | | EXECUTION_GROUP | VARCHAR(100) | Y | Execution Group | Identifies a group of programs that are logically linked (i.e. Enrichment, Pre-Process, Post-Process, ...) |
10 | | EXECUTION_STAGE | NUMERIC | Y | Execution Stage | Code execution stage |
11 | | SOURCE_CODE | VARCHAR(256) | Y | Source Code | SAS program to be executed (must be saved under irm/source/sas/nodes) |
12 | | PA_LIBREF_LIST | VARCHAR(256) | N | Persistent Area Libraries | Optional list (space separated) of PA libraries that are required by the program |
13 | | CLEAR_WORK_FLG | VARCHAR(1) | N | Clear Work Flag | Optional flag (Y/N). Controls whether to clear the SAS WORK after the program execution (defaults to N if blank) |
14
15\details
16
17This table is used to run a configurable set of sas programs at runtime.
18For a given value of the EXECUTION_GROUP variable, the execution process divided in stages where each stage is executed after the previous stage has been completed.
19Within each stage, all programs specified by the SOURCE_CODE variable are executed in parallel.
20Any libref specified inside the PA_LIBREF_LIST variable will be automatically assigned in the IRM persistence area before the execution of the corresponding SAS program: library folders will be automatically created in the IRM persistence area if they do not exist.
21The SAS Work library is cleared after the execution of a program if CLEAR_WORK_FLG = Y.
22
23Valid values for column EXECUTION_GROUP:
24 - <i>Enrichment</i>: the corresponding program is executed as part of the enrichment process
25 - <i>Any other value</i>: it can be used to extend the solution (it might require changes to the IRM jobflows)
26
27\ingroup ddlStaticAnalytics
28\author SAS Institute Inc.
29\date 2019
30*/
31
32CREATE TABLE &LIBREF..EXECUTION_CONFIG (
33 EXECUTION_GROUP VARCHAR(100) NOT NULL label = 'Execution Group',
34 EXECUTION_STAGE NUMERIC(8) NOT NULL label = 'Execution Stage',
35 SOURCE_CODE VARCHAR(256) NOT NULL label = 'Source Code',
36 PA_LIBREF_LIST VARCHAR(256) label = 'Persistent Area Libraries',
37 CLEAR_WORK_FLG VARCHAR(1) label = 'Clear Work Flag'
38);