%let indconn = %str(user='youruserid' password='yourpwd' schema=yourschema);
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. |
specifies the name for the published model.
Restriction | The model name cannot exceed 128 characters. |
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 |
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. |
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 |
specifies whether to delete the output table before running the scoring model.
Default | FALSE |
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. |
specifies whether debug messages are displayed.
Default | 0 |
Interaction | Tracing for the stored procedure is on if TRACE= is greater than zero. |
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 |
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 |
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. |
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. |
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. |