%BRM_IMPORT_FOLDER

Imports the folder definitions in the specified CSV file into the SAS Decision Manager database.

Requirement:

This macro must be run on the server tier.

Using the %BRM_IMPORT_FOLDER Macro

Format of the Folder CSV Input File

Syntax

%BRM_IMPORT_FOLDER (CSV=%STR(input_filename.CSV),
REJECT=%STR(reject_filename.CSV)<, BRM_USER=user_ID>);

Required Arguments

CSV=%STR(input_filename)

specifies the full pathname to the CSV file where you want to import the data from. For more information, see Format of the Folder CSV Input File.

REJECT=%STR(reject_filename)

specifies the full pathname to the CSV file where you want the macro to write any records that were not imported to the SAS Decision Manager database. See Using the %BRM_IMPORT_FOLDER Macro for more information.

Optional Argument

BRM_USER=user_ID

specifies the user ID that you want to be associated with the data that is imported. This user ID is associated with the imported objects in the SAS Decision Manager database and is displayed in the interface.

Default

User ID of the user that is logged on to the server and running the macro

Details

Using the %BRM_IMPORT_FOLDER Macro

Format of the Folder CSV Input File

Using the %BRM_IMPORT_FOLDER Macro

The %BRM_IMPORT_FOLDER macro enables you to create new folders. You cannot update the content in existing folders with this macro. The macro uses the pathname to determine whether a folder already exists. If the pathname already exists, then the folder is rejected.

The %BRM_IMPORT_FOLDER macro runs several validation checks as it imports the folders. For example, it checks whether each folder pathname begins with a top-level folder and verifies that individual folder names are not longer than 100 characters. If the macro finds an invalid folder definition in the CSV file, it writes a message to the SAS log, and the folder is rejected. The macro writes the input records for the rejected folder to the CSV file that was specified in the REJECT= option.

Format of the Folder CSV Input File

Each row of the CSV input file identifies a folder. 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 following table. To create a blank column in the CSV file, specify two comma separators without any content between them. For example, to create a folder named Applications and to specify a blank column for the folder description, specify the following in the CSV file:

Applications,,N,Loans/Retail

Format of the Folder CSV Input File
Column	Description	Can Column Be Blank
FOLDER_NM	The name of the folder where you want to import the contents of the CSV file.	No
FOLDER_DESC	The description of the folder.	Yes
TOP_LEVEL_FOLDER_FLG	Specifies whether the folder is a top-level folder. Specify `Y` or `N`.	No
FOLDER_PATH	The pathname to the business rules folder where you want to import the contents of the CSV file. This pathname must exist. Separate folder names with forward slashes.	No

Last updated: February 22, 2017