SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
irmst_task_enrich_pl_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 Profit & Loss Account table
7
8 \details
9
10 This node extract from the input Profit & Loss 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_profit_loss_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 In addition the following macro utilities are called:
18
19 | Macro name | Description | Further information |
20 |---------------------------|--------------------------------------------------------------------------------------------------------------|-----------------------------------------------|
21 | irm_session_prepare | Reads RUN_OPTION table and sets logging options | \link irm_session_prepare.sas \endlink |
22 | 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 |
23
24 \ingroup nodes
25 \author SAS Institute Inc.
26 \date 2018
27*/
28
29/* ************************************** */
30/* Create Enriched P&L table */
31/* ************************************** */
32
33%irmc_enrich_account(ds_in_account = st_lnd.profit_loss_account
34 , ds_in_map_account_hierarchy = st_map.map_profit_loss_hierarchy
35 , ds_in_map_geo_hierarchy = st_map.map_geo_hierarchy
36 , ds_in_map_coa = st_map.map_chart_of_account
37 , ds_in_map_movement = st_map.map_movement_type
38 , ds_in_entity = st_stg.entity
39 , ds_out = st_stg.profit_loss_account
40 );
41
42/* *********************************************************************** */
43/* Create Result List table: list all outputs created by this program */
44/* *********************************************************************** */
45
46data &ds_out_result_list.;
47 length
48 source_code $256.
49 table_name $100.
50 data_type $20.
51 status $20.
52 ;
53 /* Macro variable PROGRAM_NAME is set by macro irmc_task_runner */
54 source_code = "&program_name.";
55 table_name = "ST_STG.PROFIT_LOSS_ACCOUNT";
56 data_type = "View";
57 status = "Created";
58run;