SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
irmst_node_sync_credit_rptmart.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 Synchronize data objects for downstream execution
7
8 \details
9
10 This node ensure that all required tasks have been completed before the execution can proceed to the downstream processing (Load/Update the Reportmart)
11
12 In addition the following macro utilities are called:
13
14 | Macro name | Description | Further information |
15 |---------------------------|--------------------------------------------------------------------------------------------------------------|-----------------------------------------------|
16 | irm_session_prepare | Reads RUN_OPTION table and sets logging options | \link irm_session_prepare.sas \endlink |
17 | 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 |
18
19 \ingroup nodes
20 \author SAS Institute Inc.
21 \date 2018
22*/
23
24/* Initialize session */
25%irm_session_prepare();
26
27/* Delete reportmart_config table (if exists). It will be created using proc sql below */
28%if(%rsk_dsexist(&ds_out_reportmart_config.)) %then %do;
29 proc sql;
30 drop table &ds_out_reportmart_config.;
31 quit;
32%end;
33
34/* Create the reportmart_config table */
35proc sql;
36 create table &ds_out_reportmart_config. as
37 select
38 t2.key as ANALYSIS_DATA_KEY
39 , t1.*
40 from
41 &ds_in_reportmart_config. as t1
42 join
43 &ds_in_analysis_data. as t2 on
44 lowcase(t1.schema_name) = t2.schemaName
45 and resolve(t1.schema_version) = t2.schemaVersion
46 where
47 reportmart_group_id = "Credit Risk"
48 ;
49quit;
50
51/* Cleanup session */
52%irm_session_cleanup;