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

The table AGGREGATION_CONFIG defines aggregation rules for any given data definition. More...

Go to the source code of this file.

Detailed Description

The table AGGREGATION_CONFIG defines aggregation rules for any given data definition.

PK Variable Type Required? Label Description
SCHEMA_NAME VARCHAR(150) Y Schema Name Logical name of the table schema
SCHEMA_VERSION VARCHAR(50) Y Schema Version Identifies a specific version of the table metadata.
VARIABLE_NAME VARCHAR(32) Y Variable Name Name of the variable for which the aggregation function is being defined
AGGREGATION_METHOD VARCHAR(32) Y Aggregation Method Aggregation function: any function supported by the SUMMARY procedure. Example: SUM, MEAN, MAX, etc.
WEIGHT_VAR VARCHAR(32) N Weight Variable Name of the weight variable.

(*) indicates a required variable.

This table is used during the adjustment allocation process to define aggregation functions for each variable of the report mart tables. Any valid aggregation function supported by the SUMMARY procedure can be specified.

Author
SAS Institute Inc.
Date
2018

Definition in file aggregation_config.sas.