%BRM_EXPORT_RULESET

Exports rule sets from the SAS Decision Manager database into a CSV file. You can modify the CSV file and use it as input to the %BRM_IMPORT_RULESET macro.

Requirement:	This macro must be run on the server tier.
Tip:	You can modify the data values in the exported CSV file, and then re-import the data. However, do not modify the CSV file structure (column or row order).

Syntax

Required Arguments

Optional Argument

Syntax

%BRM_EXPORT_RULESET (RULESETS=ALL | %STR(rule_set_1<, rule_set_2>...),
CSV=%STR(output_filename.CSV)<, FOLDER_PATH=%STR(pathname)>);

Required Arguments

CSV=%STR(output_filename)

specifies the full pathname to the CSV file for the exported data.

RULESETS=ALL | %STR(rule_set_1<, rule_set_2>...)

specifies the rule sets that you want to export. Specify ALL to export all rule sets. To export only selected rule sets, specify the identification numbers of the rule sets. Separate multiple identification numbers with commas.

Example

rulesets=%str(10168,10043)

Optional Argument

FOLDER_PATH=%STR(pathname)

specifies the full pathname for the business rules folder from which you want to export rule sets. Use a forward slash to separate folder names.

If you specify a folder pathname, then only the rule sets in that folder are exported. For example, if you specify RULESETS=ALL and FOLDER_PATH=%STR(Loans/Retail), then only the rule sets in the folder Loans/Retail are exported. If you specify RULESETS=%STR(10045,10572) and FOLDER_PATH=%STR(Loans/Retail), but neither of the specified rule sets are in the Loans/Retail folder, then no rule sets are exported.

Last updated: February 22, 2017