%BRM_EXPORT_LOOKUP

Exports the contents of lookup tables into a CSV file. You can modify the CSV file and use it as input to the %BRM_IMPORT_LOOKUP 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 Argument
Optional Arguments

Syntax

%BRM_EXPORT_LOOKUP (CSV=%STR(output_filename.CSV)
<, FOLDER_PATH=%STR(pathname)>
<, LOOKUP=%STR('lookup_table_1'<, 'lookup_table_2'>...)>);

Required Argument

CSV=%STR(output_filename)

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

Optional Arguments

FOLDER_PATH=%STR(pathname)

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

If you specify a folder pathname, then only the lookup tables in that folder are exported. For example, if you specify FOLDER_PATH=%STR(Loans/Retail), then only the lookup tables in the folder Loans/Retail are exported. If you specify both LOOKUP=%STR('CountryCodes', 'ZipCodes') and FOLDER_PATH=%STR(Loans/Retail), but neither of the specified lookup tables are in the Loans/Retail folder, then no lookup tables are exported.

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

specifies names of the lookup tables that you want to export. Enclose each table name 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.
Example lookup=%str('BadVINSTates','StateCodes')
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 22, 2017