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

The table RULE_SET_CONFIG contains business rules definitions. More...

Go to the source code of this file.

Detailed Description

The table RULE_SET_CONFIG contains business rules definitions.

PK Variable Type Required? Label Description
RULE_SET_GROUP_ID VARCHAR(100) Y Rule Set Group Id Rule Set Group Identifier
PRIMARY_KEY VARCHAR(10000) N Primary Key (Optional) List of primary key variables of the source table. Only used if parameter DS_OUT_DETAILS is not blank
RULE_ID VARCHAR(32) Y Rule Id Rule Identifier
RULE_NAME VARCHAR(100) N Rule Name Rule Name
RULE_DESC VARCHAR(100) N Rule Description Rule Description
RULE_COMPONENT VARCHAR(10) Y Rule Component Specifes if the current record relates to the Condition or the Action portion of the rule.
Valid Values (case insensitive):
- Condition
- Action
OPERATOR VARCHAR(10) N Operator Boolean Operator. It can be used to combine multiple conditions within a rule.
Valid Values (case insensitive):
- <blank>
- And
- Or
-Not
-And Not
-Or Not
PARENTHESIS VARCHAR(1) N Parenthesis Opening/Closing parenthesis. It can be used to create more complex boolean conditions.
Valid Values:
- <blank>
- (
- )
COLUMN_NM VARCHAR(32) Y Column Name Required unless RULE_TYPE = "CUSTOM". Name of the variable used to build the condition expression
RULE_TYPE VARCHAR(100) Y Rule Type Controls how the expression for evaluating the condition/action is built.
RULE_DETAILS VARCHAR(4000) Y Rule Details Provides additional details needed to build the expression for evaluating the condition/action.
MESSAGE_TXT VARCHAR(4096) N Message Text Provides a custom message for reporting the results of rules evaluation. Only one message per rule can be specified: for any given rule id, the first non-blank value that is used.
LOOKUP_SCHEMA_NAME CHARACTER(100) N Lookup Schema Name Required if this rule uses a lookup table. Used to specify the schema name of the data definition for this lookup table.
LOOKUP_SCHEMA_VERSION CHARACTER(100) N Lookup Schema Version Required if this rule uses a lookup table. Used to specify the schema version of the data definition for this lookup table.
LOOKUP_TABLE_PRIMARY_KEY CHARACTER(1) N Lookup Key Source Used if this rule has a lookup table. If set to Y then only primary key variables from the lookup table are available for LOOKUP_KEY. If set to N then all variables from the lookup table are available for LOOKUP_KEY
LOOKUP_KEY VARCHAR(10000) N Lookup key Space separated list of lookup key variables. These variables must be found in both the SOURCE_TABLE and the LOOKUP table
LOOKUP_DATA VARCHAR(10000) N Lookup Data Space separated list of lookup data variables to retrieve. These variables must be found in the LOOKUP table
AGGR_VAR_NM VARCHAR(32) N Aggregated Variable Name Name (Alias) given to the result of the aggregated expression
AGGR_EXPRESSION_TXT VARCHAR(10000) N Aggregated Expression Text Summary-type of expression (i.e. SUM(<varname>).
Orthogonal query expressions can be used to perform filtered aggregation (i.e. SUM(<varname> * (<other_varname> = "some value"))
AGGR_GROUP_BY_VARS VARCHAR(10000) N Aggregated Group By Vars (Optional) Space separated list of group-by variables for the aggregation.
AGGREGATED_RULE_FLG VARCHAR(1) Y Aggregated Rule Flag Flag (Y/N). Specifies if the rule operates at the detail level (for each record of the SOURCE_TABLE) or at aggregated level
RULE_REPORTING_LEV1 VARCHAR(1024) N Rule Reporting Level 1 This field is used to classify rules for reporting purpose
RULE_REPORTING_LEV2 VARCHAR(1024) N Rule Reporting Level 2 This field is used to classify rules for reporting purpose
RULE_REPORTING_LEV3 VARCHAR(1024) N Rule Reporting Level 3 This field is used to classify rules for reporting purpose
RULE_WEIGHT NUMERIC(8) Y Rule Weight A weight assigned to the rule. Used for reporting purpose (weighted aggregation for building performance indicators)

See irm_run_rules.sas for details for details.

Author
SAS Institute Inc.
Date
2018

Definition in file rule_set_config.sas.