%BRM_EXPORT_VOCABULARY

Exports vocabularies from the rules database into a CSV file.

Restriction:

This macro must be run on the server tier.

Syntax

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

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

specifies 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 identification numbers with commas.

Tip	You can filter the vocabularies that are exported by specifying the FOLDER_PATH= option.
Example	vocab=%str('LRAutoVocab','AcmeAuto')

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 VOCAB=ALL and FOLDER_PATH=RetailLoans, then only the vocabularies in the folder RetailLoans are exported. If you specify VOCAB=%STR('loanVocab','riskVocabulary') and FOLDER_PATH=RetailLoans, but neither of the specified vocabularies are in the RetailLoans folder, then no vocabularies are exported.

Use a forward slash to separate folder names.

Example

FOLDER_PATH=Loans/Retail/Applications