The table AGGREGATION_CONFIG defines aggregation rules for any given data definition. More...
Go to the source code of this file.
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.
Definition in file aggregation_config.sas.