%let indconn = user=myuserid password=XXXX path=ortest;
specifies the Oracle user name (also called the user ID) that is used to connect to the database.
specifies the password that is associated with your Oracle 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 Oracle driver, node, and database that contains the tables and views that you want to access.
specifies the directory where the scoring model program, the properties file, 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=, and (if needed) FMTCAT= arguments. |
See | Special Characters in Directory Names |
specifies the name for the published model.
Restriction | The model filename cannot exceed 128 characters. For more information, see Oracle Scoring Files. |
specifies the name of the model table where the scoring files are published.
Default | sas_model_table |
Requirement | The name of the model table must be the same as the name specified in the %INDOR_CREATE_MODELTABLE macro. For more information, see the MODELTABLE argument in %INDOR_CREATE_MODELTABLE Macro Syntax. |
specifies the name of the scoring model program file that was created by using the SAS Enterprise Miner Score Code Export node.
Default | score.sas |
Restriction | Only DATA step programs that are produced by the SAS Enterprise Miner Score Code Export node can be used. |
Interaction | If you use the default score.sas file that is created by the SAS Enterprise Miner Score Code Export node, 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. |
The maximum number of output variables is 1000. | |
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 name of an Oracle database to which the scoring files are 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 %INDOR_CREATE_MODELTABLE macro. For more information, see the DATABASE argument in %INDOR_CREATE_MODELTABLE Macro Syntax. |
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 %INDOR_PUBLISH_MODEL Run Process. |
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 can be used. |
Interactions | If you use the default format catalog that is created by the SAS Enterprise Miner Score Code Export node, 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 the Base SAS Procedures Guide. |
specifies one of the following actions that the macro performs:
creates new files.
overwrites the current files, if files with the same name are already registered.
causes all files for this model to be dropped from the Oracle database.
Default | CREATE |
Tip | If the model has been previously published and you specify ACTION=CREATE, you receive warning messages from Oracle. If the model has been previously published and you specify ACTION=REPLACE, no warnings are issued. |
specifies a directory that contains diagnostic files.
Tip | This argument is useful when testing your scoring models. |
See | Special Characters in Directory Names |