%BRM_EXPORT_LOOKUP

Exports the contents of lookup tables into a CSV file.

Restriction: This macro must be run on the server tier.

Syntax

%BRM_EXPORT_LOOKUP (CSV=output_filename.CSV<, FOLDER_PATH=path-name>
<, LOOKUP='lookup_table_1'<, 'lookup_table_2'>...>);

Required Argument

CSV=output_filename

specifies the full pathname to the CSV file where you want to export the data.

Optional Arguments

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.

Use a forward slash to separate folder names.

Example FOLDER_PATH=Loans/Retail/Applications

LOOKUP=%STR('lookup_table_1'<, 'lookup_table_2'>...)

specifies the lookup tables that you want to export. Specify the names of the lookup tables, enclosed in single quotation marks. Separate multiple names with commas.

By default, %BRM_EXPORT_LOOKUP exports all lookup tables. You do not need to specify the LOOKUP= option unless you want to export specific tables.

Tip You can filter the lookup tables that are exported by specifying the FOLDER_PATH= option.
Example lookup=%str('BadVINSTates','StateCodes')