%let indconn = server=myserver user=myuserid password=xxxx database=mydb;
specifies the Teradata server name or the IP address of the server host.
specifies the Teradata user name (also called the user ID) that is used to connect to the database.
specifies the password that is associated with your Teradata user ID.
Tip | Use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error to occur. |
specifies the Teradata database that contains the tables and views that you want to access.
Default | Your current database |
Requirements | You must specify the DATABASE= argument if you use the SAS Embedded Process. |
If you are using Teradata 14.10 or later, excluding the first release of Teradata 15, the maximum database name length is 128 characters, and it must be a valid Teradata database name. Otherwise, the maximum length is 30 characters. |
specifies the directory where the scoring model program, the properties file, the analytic store file (if analytic store scoring), and the format catalog are located.
Restriction | You must use a fully qualified pathname. |
Interaction | If you do not use the default directory that is created by SAS Enterprise Miner, you must specify the DATASTEP=, XML= or (if analytic store scoring) STORE=, and (if needed) FMTCAT= arguments. |
See | Special Characters in Directory Names |
specifies the name that is prepended to each output function to ensure that each scoring function name is unique on the Teradata database. If you use the SAS Embedded Process, the model name is part of the .ds2 and .xml scoring filenames.
Restriction | The scoring function name is a combination of the model name and the output variable name. If you are using Teradata 14.10 or later, excluding the first release of Teradata 15, the maximum scoring function name length is 128 characters. Otherwise, the maximum length is 30 characters.For more information, see Scoring Function Names. |
Requirement | If you use scoring functions, the model name must be a valid SAS name that is ten characters or fewer. If you use the SAS Embedded Process, the model name can be up to 128 characters. For more information about valid SAS names, see the topic on rules for words and names in SAS Language Reference: Concepts. |
Interaction | Only the EM_ output variables are published as Teradata scoring functions. For more information about the EM_ output variables, see Fixed Variable Names and Scoring Function Names. |
specifies whether scoring functions or scoring files are created. MECHANISM= can have one of the following values:
specifies that scoring functions are created.
See | Using Scoring Functions to Run Scoring Models |
specifies that scoring files are created.
Requirement | If you specify MECHANISM=EP, you must also specify the MODELTABLE= argument. |
Note | The SAS Embedded Process might require a later release of Teradata than function-based scoring. For more information, see the SAS Foundation system requirements documentation for your operating environment. |
See | Using the SAS Embedded Process to Run Scoring Models |
Default | If either a score.sasast file exists or you specify STORE=analytic-store-filename, the default is EP. Otherwise, the default is STATIC. |
Interaction | If you specify MECHANISM=STATIC and either a score.sasast file exists or you specify STORE=analytic-store-filename, an error occurs. |
See | STORE=analytic-store-filename |
specifies the name of the model table where the scoring files are published.
Default | sas_model_table |
Restriction | This argument is available only when using the SAS Embedded Process. |
Requirements | The name of the model table must be the same as the name specified in the %INDTD_CREATE_MODELTABLE macro. For more information, see the MODELTABLE argument in %INDTD_CREATE_MODELTABLE Macro Syntax. |
If you are using Teradata 14.10 or later, excluding the first release of Teradata 15, the maximum table name length is 128 characters, and it must be a valid Teradata table name. Otherwise, the maximum length is 30 characters. |
specifies the name of the scoring model program file that was created by using the SAS Enterprise Miner Score Code Export node or the SAS Factory Miner HPFOREST or HPSVM component.
Default | score.sas |
Restriction | Only DATA step programs that are produced by the SAS Enterprise Miner Score Code Export node or the SAS Factory Miner HPFOREST or HPSVM component can be used. |
Interaction | If you use the default score.sas file that is created by the SAS Enterprise Miner Score Code Export node or the SAS Factory Miner HPFOREST or HPSVM component, you do not need to specify the DATASTEP= argument. |
specifies the name of the properties XML file that was created by the SAS Enterprise Miner Score Code Export node.
Default | score.xml |
Restrictions | Only XML files that are produced by the SAS Enterprise Miner Score Code Export node can be used. This argument is not applicable for analytic store models generated by SAS Factory Miner. |
If you use scoring functions to run scoring models, the maximum number of output variables is 128. If you use the SAS Embedded Process and Teradata version 13.1 or 14.0, the maximum is 1024. If you use the SAS Embedded Process and Teradata version 14.10, the maximum is 2048. | |
Interaction | If you use the default score.xml file that is created by the SAS Enterprise Miner Score Code Export node, you do not need to specify the XML= argument. |
specifies the filename of the analytic store.
Default | score.sasast |
Restriction | Only analytic store files that are produced by the SAS Factory Miner HPFOREST or HPSVM components can be used. |
Interactions | If an analytic store file exists in the input directory (DIR=), the %INDTD_PUBLISH_MODEL macro attempts to publish that object. Alternatively, you can specify the name of the analytic store in the STORE= argument. |
If you specify MECHANISM=STATIC and either a score.sasast file exists or you specify STORE=analytic-store-filename, an error occurs. | |
See | DIR=input-directory-path |
MECHANISM=STATIC | EP |
specifies the name of a Teradata database to which the scoring functions and formats or the scoring files are published.
Default | The database specified in the INDCONN macro variable or your current database |
Requirements | If you use the SAS Embedded Process, the name of the database must be the same as the database specified in the %INDTD_CREATE_MODELTABLE macro. For more information, see the DATABASE argument in %INDTD_CREATE_MODELTABLE Macro Syntax. |
If you are using Teradata 14.10 or later, excluding the first release of Teradata 15, the maximum database name length is 128 characters, and it must be a valid Teradata database name. Otherwise, the maximum length is 30 characters. | |
Interaction | The database that is specified by the DATABASE argument takes precedence over the database that you specify in the INDCONN macro variable. For more information, see %INDTD_PUBLISH_MODEL Macro Run Process. |
Tip | You can publish the scoring functions and formats or the scoring files to a shared database where other users can access them. |
specifies the name of the format catalog file that contains all user-defined formats that were created by the FORMAT procedure and that are referenced in the DATA step scoring model program.
Restriction | Only format catalog files that are produced by the SAS Enterprise Miner Score Code Export node or the SAS Factory Miner HPFOREST or HPSVM component can be used. |
Interactions | If you use the default format catalog that is created by the SAS Enterprise Miner Score Code Export node or the SAS Factory Miner HPFOREST or HPSVM component, you do not need to specify the FMTCAT= argument. |
If you do not use the default catalog name (FORMATS) or the default library (WORK or LIBRARY) when you create user-defined formats, you must use the FMTSEARCH system option to specify the location of the format catalog. For more information, see PROC FORMAT in Base SAS Procedures Guide. | |
Note | The analytic store file includes format catalog information. However, you can specify a different format catalog by using the FMTCAT= argument. |
specifies one of the following actions that the macro performs:
creates new functions or files.
overwrites the current functions or files, if functions or files with the same name are already registered.
causes all functions or files for this model to be dropped from the Teradata database.
Default | CREATE |
Tip | If the function or file has been previously defined and you specify ACTION=CREATE, you receive warning messages from Teradata. If the function or file has been previously defined and you specify ACTION=REPLACE, no warnings are issued. |
specifies whether the running code is isolated in a separate process in the Teradata database so that a program fault does not cause the database to stop.
Default | PROTECTED |
Restriction | This argument is valid only when . It has no effect if you specify MECHANISM=EP. |
Tip | After a function is validated in PROTECTED mode, it can be republished in UNPROTECTED mode. This can result in a significant performance gain. |
specifies a directory that contains diagnostic files.
Tip | This argument is useful when testing your scoring models. |
See | Special Characters in Directory Names |