Running the %INDHN_RUN_MODEL Macro

%INDHN_RUN_MODEL Macro Run Process

To run the %INDHN_RUN_MODEL macro, follow these steps:

Start SAS and submit the following command in the Program Editor or Enhanced Editor:
```
%let indconn = %str(user='youruserid' password='yourpwd'
    schema=yourschema);
```
The arguments supplied to the INDCONN macro variable can vary. For more information, see the INDCONN Macro Variable.
Run the %INDHN_RUN_MODEL macro.

For more information, see %INDHN_RUN_MODEL Macro Syntax.

Messages are written to the SAS log to indicate the success or failure of the creation of the .ds2 and .xml scoring files.

%INDHN_RUN_MODEL Macro Syntax

%INDHN_RUN_MODEL

(DATABASE=database-name
, MODELNAME=name
, INPUTTABLE=<<">input-schema<".>><">input-table-name<">
, OUTPUTTABLE=<<">output-schema<".>><">output-table-name<">
<, MODELTABLE=<<">model-schema<".>><">model-table-name<">>
<, KEEP=column-keep-list>
<, TRACE=trace-level>
<, FORCEOVERWRITE=TRUE | FALSE>
<, SASTRACETABLE=sas-trace-table-name>
<, EPTRACETABLE=<<">schema<".>><">ep-trace-table-name<">>
<, NUMTHREADS=number-of-threads>
<, NUMDATAPARTITIONS=number-of-partitions>
<, DBMAXTEXT=string-length>
);

Arguments

DATABASE=database-name

specifies the name of the ODBC data source for the SAP HANA system to which the output table is published.

Default	The database specified in the INDCONN macro variable
Requirement	The name of the database must be the same as the database specified in the %INDHN_CREATE_MODELTABLE macro. For more information, see the DATABASE argument in %INDHN_CREATE_MODELTABLE Macro Syntax.
Interaction	The database that is specified by the DATABASE argument takes precedence over the server, port, or instance value that you specify in the INDCONN macro variable. For more information, see INDCONN Macro Variable.

MODELNAME=name

specifies the name for the published model.

Restriction

The model name cannot exceed 128 characters.

INPUTTABLE=<<">input-schema<">.><">input-table-name<">

specifies the name of the scoring model input table.

Requirement	If the input table name is case sensitive, you must set the INDCONN macro variable’s PRESERVE_TAB_NAMES argument to YES.
See	INDCONN Macro Variable

OUTPUTTABLE=<<">output-schema<">.><">output-table-name<">

specifies the name of the scoring model output table.

Requirement

If the output table name is case sensitive, you must set the INDCONN macro variable’s PRESERVE_TAB_NAMES argument to YES.

MODELTABLE=<<">model-schema<">.><">model-table-name<">

specifies the name of the model table where the scoring files are published with the %INDHN_CREATE_MODELTABLE and %INDHN_PUBLISH_MODEL macros.

Default	SAS_MODEL_TABLE
Requirements	The name of the model table must be the same as the name specified in the %INDHN_CREATE_MODELTABLE and %INDHN_PUBLISH_MODEL macros. For more information, see the MODELTABLE argument in %INDHN_CREATE_MODELTABLE Macro Syntax and %INDHN_RUN_MODEL Macro Syntax.
	The maximum table name length is 30 characters, and it must be a valid SAP HANA table name.
	If the model table name is case sensitive, you must set the INDCONN macro variable’s PRESERVE_TAB_NAMES argument to YES.
See	INDCONN Macro Variable

FORCEOVERWRITE=TRUE | FALSE

specifies whether to delete the output table before running the scoring model.

Default

FALSE

KEEP=variable-keep-list

specifies the column or columns to keep in the output table.

Requirement

The list of variables must be separated by spaces and should not be enclosed by single or double quotation marks.

TRACE= trace-level

specifies whether debug messages are displayed.

Default	0
Interaction	Tracing for the stored procedure is on if TRACE= is greater than zero.

SASTRACETABLE=sas-trace-data-set-name

specifies the name of a SAS data set for tracing messages generated by the call to a stored procedure.

Default	WORK.SASEP_LOG
Interaction	Tracing for the stored procedure is on if TRACE= is greater than zero.
See	TRACE= trace-level

EPTRACETABLE=<<">schema<">.><">ep-trace-table-name<">

specifies the name of the SAP HANA table for logging.

Requirement	If the trace table name is case sensitive, you must set the INDCONN macro variable’s PRESERVE_TAB_NAMES argument to YES.
Interaction	Tracing for the stored procedure is on if TRACE= is greater than zero.
Note	If ep-trace-table-name starts with a number sign (#), a local temporary table is used. The table is deleted at the end of the session. If ep-trace-table-name does not start with a number sign (#), a permanent table is created in SAP HANA.
See	TRACE= trace-level
See	INDCONN Macro Variable

NUMTHREADS=number-of-threads

specifies the number of DS2 threads used to run the scoring model.

Default	1
See	For more information about DS2 threads, see SAS DS2 Language Reference.

NUMDATAPARTITIONS=number-of-data-partitions

specifies the number of data partitions used for DS2 processing.

Default	1
Tip	The default value of 1 should be used for in-database scoring. You can change the value of NUMDATAPARTITIONS if you are using High-Performance Analytics.

DBMAXTEXT=string-length

specifies the default maximum string length for character input columns.

Default	1024 characters
Note	The length of the string is also reflected in the output table.