SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
irmst_node_prep_agg_tables.sas File Reference

partition node, prepares the input/configuration tables for aggregation More...

Go to the source code of this file.

Detailed Description

partition node, prepares the input/configuration tables for aggregation

Parameters
[in]ST_PRM.RUN_OPTIONparameter table
[in]%ds_in_bep_summary= ST_STG.BEP_SUMMARY Input table containing a list of the Business Evolution Plans associated with this Analysis Run
[in]%ds_in_bep_details= ST_STG.BEP_DETAILS Input table containing details of the Business Evolution Plans associated with this Analysis Run
[in]%ds_in_agg_rules_config= ST_CFG.AGGREGATION_RULES_CONFIG Contains the rules for aggregating the credit risk detail results
[in]%ds_in_bsp_data_config= ST_CFG.BSP_DATA_CONFIG Contains information on the source table and scenario name
[out]%ds_out_agg_rules_config= P_ST_STG.AGGREGATION_RULES_CONFIG Output table containing the aggregation rules filtered to include only those with a schema name/version matching the planning data in the BSP summary
[out]%ds_out_credit_risk_detail= P_ST_STG.AGG_SRC_TBL Output table containing the results from the source tbl filtered by scenario and only including variables needed for aggregation
[out]%ds_out_bsp_data_config= P_ST_STG.BSP_DATA_CONFIG Contains information on the source table and scenario name filtered by source.

This node filters the aggregation rules configuration table based on the planning data schemas found in the BSP summary table. It also retrieves the source data from the provided instance key and filters by scenario, only keeping the variables needed based on the aggregation rules configuration table. The table bsp_data_config is partitioned to include only one source per partition.

In addition the following macro utilities are called:

Macro name Description Further information
irm_session_prepare Reads RUN_OPTION table and sets logging options irm_session_prepare.sas
irm_session_cleanup Removes all non-IRM WORK datasets/views and deletes all user-created macro variables from workspace session irm_session_cleanup.sas
irmst_fltr_src_agg_tbl Filters the source table by scenario name irmst_fltr_src_agg_tbl.sas
Author
SAS Institute Inc.
Date
2018

Definition in file irmst_node_prep_agg_tables.sas.