Creating a Model Table :: SAS(R) 9.3 In-Database Products: User's Guide, Second Edition

Overview

When publishing a model in Oracle that has the SAS Embedded Process deployed, you must create a table to hold the sasscore_modelname.ds2 and sasscore_modelname_ufmt.xml scoring files. You must run the %INDOR_CREATE_MODELTABLE macro to create the table before you run the %INDOR_PUBLISH_MODEL macro.

You have to create the table only one time to hold a model’s scoring files.

The model table contains the following columns. The ModelName column is the table key. The table is referenced by the two-level name schema-name.model-table-name.

Column Name	Description	Specification
ModelName	contains the name of the model	VARCHAR(128)
ModelDS2	contains the sasscore_modelname.ds2 file	BLOB not null
ModelFormats	contains the sasscore_modelname_ufmt.xml file	BLOB
ModelMetadata	reserved by SAS for future use	BLOB

%INDOR_CREATE_MODELTABLE Run Process

To run the %INDOR_CREATE_MODELTABLE macro, complete the following steps:

Start SAS 9.3 and submit the following commands in the Program Editor or Enhanced Editor:
```
%indorpm;
%let indconn = user=myuserid password=xxxx path=ortest;
```
For more information, see %INDORPM Macro and the INDCONN Macro Variable.
Run the %INDOR_CREATE_MODELTABLE macro.

For more information, see %INDOR_CREATE_MODELTABLE Macro Syntax.

%INDOR_CREATE_MODELTABLE Macro Syntax

%INDOR_CREATE_MODELTABLE

(<DATABASE=database-name>
<, MODELTABLE=model-table-name>
<, ACTION=CREATE | REPLACE | DROP>
);

Arguments

DATABASE=database-name

specifies the name of an Oracle database where the sasscore_modelname.ds2 and sasscore_modelname_ufmt.xml scoring files are held.

Default

The database specified in the INDCONN macro variable

MODELTABLE=model-table-name

specifies the name of the table that holds the sasscore_modelname.ds2 and sasscore_modelname_ufmt.xml scoring files.

Default	sas_model_table
Requirement	The maximum table name length is 30 characters, and it must be a valid Oracle table name.
Interaction	The table name that you specify for this macro must be the same table name that is used in the %INDOR_PUBLISH_MODEL macro.
See	%INDOR_PUBLISH_MODEL Macro Syntax

ACTION = CREATE | REPLACE | DROP

specifies one of the following actions that the macro performs:

CREATE

creates a new table.

Tip	If the table has been previously defined and you specify ACTION=CREATE, an error is issued.

REPLACE

overwrites the current table, if a table with the same name is already registered.

Tip	If you specify ACTION = REPLACE, and the current table contains sasscore_modelname.ds2 and sasscore_modelname_ufmt.xml files, the files are deleted and an empty table is re-created.

DROP: causes all models in this table to be dropped.

Default

CREATE