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

Apply aggregation rules that map a table onto itself (e.g. rollup rules) More...

Go to the source code of this file.

Detailed Description

Apply aggregation rules that map a table onto itself (e.g. rollup rules)

Parameters
[in]aggregation_rulesDataset with agrgegation rules. This is meant to be aggregation_rules_config or some subset of it.
[in]schema_nameSchema name associated with the data to apply the mapping to
[in]schema_versionSchema version associated with the data to apply the mapping to
[in]input_dsThe table that the aggregation will be applied to.
[in]period_columnThe name of the column in input_ds that represents the time horizon. If all values are at the same time horizon, add a dummy column and set the value to 0.
[out]output_dsName of the dataset to create - input_ds with aggregations applied.

Rows in aggregation_rules_config that have the same schema name and version for the source and target tables represent aggregation rules that define values in a dataset as functions of other values in the same dataset. For these rules, the src_where_cond column contains the logic that defines how the target value is updated. To reference values from the table, the notation GETVAL(ID,PERIOD) is used. ID should be a string that matches some value of the column specified in SRC_COL. PERIOD should be an integer and references the lag relative to the current row's period. For example GETVAL(GL_ASSET_LONOUTST_AUTO,0) with SRC_COL = GL_ACCOUNT_ID references the row in the table with 'GL_ASSET_LONOUTST_AUTO' as the GL_ACCOUNT_ID at the current period.

Author
SAS Institute Inc.
Date
2019

Definition in file irmc_apply_rollup_aggregation.sas.