SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
irmst_node_recombine_bep.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 Collect data from multiple IRM partition tables into multipple unpartitioned tables.
7
8
9 \details
10
11 This node calls macro \link rsk_recombine_bep.sas \endlink to append results from multiple IRM data partitions into multiple unpartitioned tables.
12
13 In addition the following macro utilities are called:
14
15 | Macro name | Description | Further information |
16 |---------------------------|--------------------------------------------------------------------------------------------------------------|-----------------------------------------------|
17 | irm_session_prepare | Reads RUN_OPTION table and sets logging options | \link irm_session_prepare.sas \endlink |
18 | 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 |
19
20 \ingroup nodes
21 \author SAS Institute Inc.
22 \date 2018
23*/
24
25/* Initialize session */
26%irm_session_prepare();
27
28/* Expand the BEP summary table to one record per planning data */
29data work.bep_summary_exp;
30 set &ds_in_summary.;
31 original_targetVariable = targetVariable;
32 original_accountID = accountID;
33 original_planningDataKey = planningDataKey;
34 original_dataDefSchemaName = dataDefSchemaName;
35 original_dataDefSchemaVersion = dataDefSchemaVersion;
36 do i=1 to countw(original_targetVariable,",");
37 targetVariable = scan(original_targetVariable,i,",");
38 accountID = scan(original_accountID,i,",");
39 planningDataKey = scan(original_planningDataKey,i,",");
40 dataDefSchemaName = scan(original_dataDefSchemaName,i,",");
41 dataDefSchemaVersion = scan(original_dataDefSchemaVersion,i,",");
42 output;
43 end;
44 drop original_: i;
45run;
46
47/* Collect all partitions */
48%irmst_recombine_bep(IN_DS_NM = &DS_IN.
49 , DS_IN_BEP_SUMMARY= work.bep_summary_exp
50 , DS_IN_BSP_CONFIG= &DS_IN_CONFIG.
51 , DS_IN_UN_AGG_TBLS= &DS_IN_UN_AGG_INF.
52 , LIB_PREFIX = &LIBPREFIX.
53 , PARTITION_NO = &MAX_RANK.
54 , O_DS = &DS_OUT_TBLS_INFO.
55 );
56
57/* Cleanup session */
58%irm_session_cleanup;