Running the %INDHN_RUN_MODEL Macro

%INDHN_RUN_MODEL Macro Run Process

To run the %INDHN_RUN_MODEL macro, follow these steps:
  1. 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.
  2. 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

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
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 maximum string length for character input columns, such as CLOB and NCLOB, that otherwise do not have a specified maximum string length.

Default 1024
Restriction This argument applies only to CLOB and NCLOB columns.
Tip This argument can be used to avoid truncation of CLOB and NCLOB column values that contain more than 1024 characters.