%BRM_IMPORT_VOCABULARY

The %BRM_IMPORT_VOCABULARY macro enables you to add new vocabulary terms. You cannot use the macro to update existing terms.

The %BRM_IMPORT_VOCABULARY macro runs several validation checks as it imports the vocabulary terms. For example, it verifies that term, entity, and vocabulary names are valid, and ensures that a term is not duplicated in a vocabulary. If the macro finds a validation error, it writes a message to the SAS log, and the term is rejected. The macro writes the input records for the rejected term to the CSV file that was specified in the REJECT= option.

When you run the %BRM_IMPORT_VOCABULARY macro, it creates a lock table in the rules database named lock_import_vocabulary. The SAS log states which user holds the lock and the time at which the lock started. It is possible for this lock to remain in place after the macro has finished. If this happens, you can override the lock by specifying the BYPASSLOCK=Y option when you run the macro.

Each row of the CSV input file defines a term, including the term data type, domain type, and the entity and vocabulary that contains the term. The CSV file must contain all of the columns listed in the following table, in the order listed. You must specify values for all columns, except as noted in the table. To create a blank column in the CSV file, specify two comma separators without any content between them. For example, to add a term to the entity named Customer in the vocabulary named loanVocab and to specify a blank column for the vocabulary description, specify the following in the CSV file:

loanVocab,,Customer