%BRM_EXPORT_VOCABULARY

Exports vocabularies 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_VOCABULARY 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_VOCABULARY (
VOCAB=ALL| %STR('vocabulary_1'<, 'vocabulary_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.

VOCAB=ALL | %STR('vocabulary_1'<, 'vocabulary_2'>...)

specifies the names of the vocabularies that you want to export. Specify ALL to export all vocabularies. To export only selected vocabularies, specify the names of the vocabularies enclosed in quotation marks. Separate multiple names with commas.

Example

vocab=%str('LRAutoVocab','AcmeAuto')

Optional Argument

FOLDER_PATH=%STR(pathname)

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

If you specify a folder pathname, then only the vocabularies in that folder are exported. For example, if you specify VOCAB=ALL and FOLDER_PATH=%STR(Loans/Retail), then only the vocabularies in the folder Retail are exported. If you specify VOCAB=%STR('loanVocab','riskVocabulary') and FOLDER_PATH=%STR(Loans/Retail), but neither of the specified vocabularies are in the Retail folder, then no vocabularies are exported.

Last updated: February 22, 2017