SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
irmst_node_get_unagg_data.sas
Go to the documentation of this file.
1/*
2 Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA
3*/
4
5/** \file
6 \brief Gets the target tables that will not be aggregated.
7
8 \param[in] ST_PRM.RUN_OPTION parameter table
9 \param[in] %ds_in_bep_summary = ST_STG.BEP_SUMMARY Input table containing a list of the Business Evolution Plans associated with this Analysis Run
10 \param[in] %ds_in_agg_rules_config = ST_CFG.AGGREGATION_RULES_CONFIG Contains the rules for aggregating the credit risk detail results
11 \param[in] %ds_in_bsp_data_config = ST_CFG.BSP_DATA_CONFIG Contains information on the source table and scenario name
12 \param[out] %ds_out_info_tbl = ST_STG.UN_AGG_TBLS_INFO Syncronization table.
13
14 \details
15
16 This node uses the aggregation rules configuration table to obtain the observations from the target tables that will not be aggregated. For more detail
17 see \link irmst_get_unagg_data.sas \endlink
18
19 In addition the following macro utilities are called:
20
21 | Macro name | Description | Further information |
22 |---------------------------|--------------------------------------------------------------------------------------------------------------|-----------------------------------------------|
23 | irm_session_prepare | Reads RUN_OPTION table and sets logging options | \link irm_session_prepare.sas \endlink |
24 | irm_session_cleanup | Removes all non-IRM WORK datasets/views and deletes all user-created macro variables from workspace session | \link irm_session_cleanup.sas \endlink |
25
26 \ingroup nodes
27 \author SAS Institute Inc.
28 \date 2018
29*/
30
31
32/* Initialize session */
33%irm_session_prepare();
34
35/* Expand the BEP summary table to one record per planning data */
36data work.bep_summary_exp;
37 set &ds_in_bep_summary.;
38 original_targetVariable = targetVariable;
39 original_accountID = accountID;
40 original_planningDataKey = planningDataKey;
41 original_dataDefSchemaName = dataDefSchemaName;
42 original_dataDefSchemaVersion = dataDefSchemaVersion;
43 do i=1 to countw(original_targetVariable,",");
44 targetVariable = scan(original_targetVariable,i,",");
45 accountID = scan(original_accountID,i,",");
46 planningDataKey = scan(original_planningDataKey,i,",");
47 dataDefSchemaName = scan(original_dataDefSchemaName,i,",");
48 dataDefSchemaVersion = scan(original_dataDefSchemaVersion,i,",");
49 output;
50 end;
51 drop original_: i;
52run;
53
54%irmst_get_unagg_data(ds_in_agg_rules_config= &ds_in_agg_rules_config.
55 ,ds_in_bep_summary= work.bep_summary_exp
56 ,ds_in_bsp_data_config= &ds_in_bsp_data_config.
57 ,out_libref = %scan(&ds_in_bep_summary., 1, .)
58 ,ds_out_info_tbl= &ds_out_info_tbl.);
59
60/* Cleanup session */
61%irm_session_cleanup;