SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
reportmart_aggregation_config.sas
Go to the documentation of this file.
1/* Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4\file
5\anchor reportmart_aggregation_config
6\brief The table REPORTMART_AGGREGATION_CONFIG controls how reportmart data should be aggregated when loading to LASR.
7
8 | PK | Variable | Type | Required? | Label | Description |
9 |--------------|----------------------------|----------------|------------|--------------------------------|---------------------------------------------------------------------|
10 | ![ ](pk.jpg) | <b>REPORTMART_GROUP_ID</b> | VARCHAR(32) | Y | Reportmart Group Identifier | Reportmart Group Identifier |
11 | ![ ](pk.jpg) | <b>SCHEMA_NAME</b> | VARCHAR(100) | Y | Schema Name | Schema Name |
12 | ![ ](pk.jpg) | <b>SCHEMA_VERSION</b> | VARCHAR(50) | Y | Schema Version | Schema Version |
13 | ![ ](pk.jpg) | <b>MART_TABLE_NAME</b> | VARCHAR(100) | Y | Mart Table Name | Name of the target Report Mart table |
14 | ![ ](pk.jpg) | <b>VAR_NAME</b> | VARCHAR(32) | Y | Variable Name | Name of the variable involved in the aggregation |
15 | ![ ](pk.jpg) | <b>VAR_SCOPE</b> | VARCHAR(32) | Y | Variable Role | The role of the variable in the aggregation: <br> - GROUP_BY: Group-by variable <br> - COUNT: Row Count <br> - DISTINCT: Distinct Count <br> - MIN: Minimum <br> - MEAN: Average <br> - MAX: Maximum <br> - SUM: Simple Sum<br> - WSUM: Weighted Sum |
16 | ![ ](pk.jpg) | <b>ALIAS</b> | VARCHAR(32) | Y | Aggregated Variable Name | Name given to the aggregated variable |
17 | | WEIGHT_VAR | VARCHAR(32) | N | Weight Variable | Name of the weight variable. Relevant when VAR_SCOPE = "WSUM" |
18
19\details
20
21 See \link irmc_node_load_reportmart.sas \endlink for details.
22
23\ingroup ddlStaticAnalytics
24\author SAS Institute Inc.
25\date 2018
26*/
27
28CREATE TABLE &LIBREF..REPORTMART_AGGREGATION_CONFIG (
29 REPORTMART_GROUP_ID VARCHAR(32) label = 'Reportmart Group Identifier',
30 SCHEMA_NAME VARCHAR(100) label = 'Schema Name',
31 SCHEMA_VERSION VARCHAR(50) label = 'Schema Version',
32 MART_TABLE_NAME VARCHAR(100) label = 'Mart Table Name',
33 VAR_NAME VARCHAR(32) label = 'Variable Name',
34 VAR_SCOPE VARCHAR(32) label = 'Variable Role',
35 ALIAS VARCHAR(32) label = 'Aggregated Variable Name',
36 WEIGHT_VAR VARCHAR(32) label = 'Weight Variable',
37 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTMART_GROUP_ID, SCHEMA_NAME, SCHEMA_VERSION, MART_TABLE_NAME, VAR_NAME, VAR_SCOPE, ALIAS)
38);