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

The table AGGREGATION_RULES_CONFIG contains parameters for the BEP jobflow execution. More...

Go to the source code of this file.

Detailed Description

The table AGGREGATION_RULES_CONFIG contains parameters for the BEP jobflow execution.

PK Variable Type Required? Label Description
TGT_TABLE_SCHEMA_NM VARCHAR(150) Y Target Schema Name Schema name of the target table
TGT_TABLE_SCHEMA_VER VARCHAR(50) Y Target Schema Version Schema version of the target table
TGT_TBL_VAL_COL VARCHAR(32) Y Target Value Column Variable name where aggregation should be applied
TGT_TBL_ID_COL VARCHAR(32) Y Target Id Column Column in target table with unique identifier for filtering and application of aggregated value
TGT_TBL_ID_VAL VARCHAR(100) Y Target Id Value Value in target id column to use for filtering application of aggregated value
SRC_TABLE_SCHEMA_NM VARCHAR(150) Y Source Schema Name Schema name of the source table
SRC_TABLE_SCHEMA_VER VARCHAR(50) Y Source Schema Version Schema version of the source table
SRC_COL VARCHAR(32) Y Source Column Variable that should be aggregated
SRC_WHERE_COND VARCHAR(4000) Y Source Where Condition Filtering condition for aggregation
SRC_WHERE_VARS VARCHAR(2000) Y Source Where Variables Filtering condition for aggregation
AGGREGATION_RULE VARCHAR(20) Y Aggregation Method Method for aggregation
WEIGHT_VAR VARCHAR(100) Y Weight Variable Weight variable for aggregation

This table is used during the balance sheet projection to retrieve aggregation rules for GL and PL tables. Any valid aggregation function supported by the proc SUMMARY procedure can be specified.

Author
SAS Institute Inc.
Date
2019

Definition in file aggregation_rules_config.sas.