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

The table REPORTMART_AGGREGATION_CONFIG controls how reportmart data should be aggregated when loading to LASR. More...

Go to the source code of this file.

Detailed Description

The table REPORTMART_AGGREGATION_CONFIG controls how reportmart data should be aggregated when loading to LASR.

PK Variable Type Required? Label Description
REPORTMART_GROUP_ID VARCHAR(32) Y Reportmart Group Identifier Reportmart Group Identifier
SCHEMA_NAME VARCHAR(100) Y Schema Name Schema Name
SCHEMA_VERSION VARCHAR(50) Y Schema Version Schema Version
MART_TABLE_NAME VARCHAR(100) Y Mart Table Name Name of the target Report Mart table
VAR_NAME VARCHAR(32) Y Variable Name Name of the variable involved in the aggregation
VAR_SCOPE VARCHAR(32) Y Variable Role The role of the variable in the aggregation:
- GROUP_BY: Group-by variable
- COUNT: Row Count
- DISTINCT: Distinct Count
- MIN: Minimum
- MEAN: Average
- MAX: Maximum
- SUM: Simple Sum
- WSUM: Weighted Sum
ALIAS VARCHAR(32) Y Aggregated Variable Name Name given to the aggregated variable
WEIGHT_VAR VARCHAR(32) N Weight Variable Name of the weight variable. Relevant when VAR_SCOPE = "WSUM"

See irmc_node_load_reportmart.sas for details.

Author
SAS Institute Inc.
Date
2018

Definition in file reportmart_aggregation_config.sas.