SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
aggregation_config.sas
Go to the documentation of this file.
1/*
2 Copyright (C) 2015 SAS Institute Inc. Cary, NC, USA
3*/
4
5/**
6 \file
7 \brief The table AGGREGATION_CONFIG defines aggregation rules for any given data definition.
8
9 |PK |Variable |Type | Required? |Label |Description |
10 |---|----------------------|------------------|-----------|--------------------------|-------------------------------------------------------------------------------------------------------|
11 | | SCHEMA_NAME | VARCHAR(150) | Y | Schema Name | Logical name of the table schema |
12 | | SCHEMA_VERSION | VARCHAR(50) | Y | Schema Version | Identifies a specific version of the table metadata. |
13 | | VARIABLE_NAME | VARCHAR(32) | Y | Variable Name | Name of the variable for which the aggregation function is being defined |
14 | | AGGREGATION_METHOD | VARCHAR(32) | Y | Aggregation Method | Aggregation function: any function supported by the SUMMARY procedure. Example: SUM, MEAN, MAX, etc. |
15 | | WEIGHT_VAR | VARCHAR(32) | N | Weight Variable | Name of the weight variable. |
16
17 (*) indicates a required variable.
18
19
20 \details
21
22 This table is used during the adjustment allocation process to define aggregation functions for each variable of the report mart tables.
23 Any valid aggregation function supported by the SUMMARY procedure can be specified.
24
25 \ingroup ddlStaticAnalytics
26 \author SAS Institute Inc.
27 \date 2018
28*/
29CREATE TABLE &LIBREF..AGGREGATION_CONFIG (
30 SCHEMA_NAME VARCHAR(150) label='Schema Name',
31 SCHEMA_VERSION VARCHAR(50) label='Schema Version',
32 VARIABLE_NAME VARCHAR(32) label='Variable Name',
33 AGGREGATION_METHOD VARCHAR(32) label='Aggregation Method',
34 WEIGHT_VAR VARCHAR(32) label='Weight variable'
35 );