SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
irmst_task_enrich_gl_account.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 Enrich General Ledger Account table
7
8 \details
9
10 This node extract from the input General Ledger Account table the records that match entries in the input Entity table.
11 Data enrichment is performed to lookup dimensional information from the following mapping tables:
12 - \link map_balance_sheet_hierarchy.sas \endlink
13 - \link map_geo_hierarchy.sas \endlink
14 - \link map_chart_of_account.sas \endlink
15 - \link map_movement_type.sas \endlink
16
17
18 In addition the following macro utilities are called:
19
20 | Macro name | Description | Further information |
21 |---------------------------|--------------------------------------------------------------------------------------------------------------|-----------------------------------------------|
22 | irm_session_prepare | Reads RUN_OPTION table and sets logging options | \link irm_session_prepare.sas \endlink |
23 | 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 |
24
25 \ingroup nodes
26 \author SAS Institute Inc.
27 \date 2018
28*/
29
30
31/* ************************************** */
32/* Create Enriched GL Account table */
33/* ************************************** */
34
35%irmc_enrich_account(ds_in_account = st_lnd.gl_account
36 , ds_in_map_account_hierarchy = st_map.map_balance_sheet_hierarchy
37 , ds_in_map_geo_hierarchy = st_map.map_geo_hierarchy
38 , ds_in_map_coa = st_map.map_chart_of_account
39 , ds_in_map_movement = st_map.map_movement_type
40 , ds_in_entity = st_stg.entity
41 , ds_out = st_stg.gl_account
42 );
43
44/* *********************************************************************** */
45/* Create Result List table: list all outputs created by this program */
46/* *********************************************************************** */
47
48data &ds_out_result_list.;
49 length
50 source_code $256.
51 table_name $100.
52 data_type $20.
53 status $20.
54 ;
55 /* Macro variable PROGRAM_NAME is set by macro irmc_task_runner */
56 source_code = "&program_name.";
57 table_name = "ST_STG.GL_ACCOUNT";
58 data_type = "View";
59 status = "Created";
60run;
61
62