%BRM_EXPORT_RULESET

Exports rule sets from the rules database into a CSV file.

Restriction:

This macro must be run on the server tier.

Syntax

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

Required Arguments

CSV=output_filename

specifies the full pathname to the CSV file where you want to export the 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 enclosed in quotation marks. Separate multiple identification numbers with commas.

Tip	You can filter the rule sets that are exported by specifying the FOLDER_PATH= option.
Example	rulesets=%str(168,43)

Optional Argument

FOLDER_PATH=path_name

specifies a business rules folder pathname in SAS Business Rules Manager that you want to filter the output by. If you specify a folder pathname, then only the objects in that path are exported. For example, if you specify RULESETS=ALL and FOLDER_PATH=RetailLoans, then only the rule sets in the folder RetailLoans are exported. If you specify RULESETS=%STR(10045,10572) and FOLDER_PATH=RetailLoans, but neither of the specified rule sets are in the RetailLoans folder, then no rule sets are exported.

Use a forward slash to separate folder names.

Example

FOLDER_PATH=Loans/Retail/Applications