%BRM_CREATE_TEMP_TERM

Reads a CSV file or a SAS data set and produces a SAS data set named WORK.TERM that can be used as input to the %BRM_LOAD_VOCABULARY macro.

Restriction:

This macro must be run on the server tier.

Syntax

%BRM_CREATE_TEMP_TERM (DATAFILE=input_file<, BRM_USER=user_ID>);

Required Argument

DATAFILE=input_file

specifies either a SAS data set name or the full pathname to a CSV file. If the input file is a CSV file, the first row of the file must contain valid SAS column names, and the remaining rows must contain column values. The column values can be numeric or character data only. You cannot specify SAS informats in the column data. The column names must be unique. For example, a simple CSV file that specifies two columns, both with numeric data, might look like the following:

patientID,BloodPressure
1,140
2,141
3,142

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 rules database and is displayed in the SAS Business Rules Manager interface.

Default

User ID of the user that is running the macro

Details

This macro reads a CSV file or SAS data set that defines vocabulary terms and that creates a SAS data set named WORK.TERM. You can use the WORK.TERM data set as input to the %BRM_LOAD_VOCABULARY macro. The %BRM_LOAD_VOCABULARY macro loads the vocabulary terms into the rules database. See %BRM_LOAD_VOCABULARY for more information.

The %BRM_CREATE_TEMP_TERM macro derives domain types and domain values for the vocabulary terms based on the data type of the term as described in Domain Types and Values for Input Terms.

Domain Types and Values for Input Terms
Term Data Type	Derived Domain Type	Derived Domain Values
Character	Discrete	If there are ten or fewer distinct values in the input data, all of the values are included in the list of domain values. If there are greater than ten distinct values in the input data, individual values are not listed in the domain values.
Date	Continuous	No input values are included in the list of domain values.
Datetime	Continuous	No input values are included in the list of domain values.
Boolean	Boolean	True and False
Numeric	If there are ten or fewer distinct values in the input data, the domain type is Discrete. If there are greater than ten distinct values, the domain type is Continuous.	For Discrete domain types, all of the values in the input data are included in the list of domain values. For Continuous domain types, only the minimum and maximum values are included in the list of domain values.