%let indconn = user=myuserid password=XXXX dsn=ncluster <schema=myschema>;
%let indconn = user=myuserid password=XXXX server=myserver database=mydatabase <schema=myschema>;
specifies the Aster user name (also called the user ID) that is used to connect to the database.
specifies the password that is associated with your Aster user ID.
Tip | Use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error. |
specifies the configured Aster data source to which you want to connect.
Requirement | You must specify either the DSN= argument alone, or the SERVER= and DATABASE= arguments together in the INDCONN macro variable. |
specifies the Aster database that contains the tables and views that you want to access.
Requirement | You must specify either the DSN= argument alone, or the SERVER= and DATABASE= arguments together in the INDCONN macro variable. |
specifies the Aster server name or the IP address of the server host.
Requirement | You must specify either the DSN= argument alone, or the SERVER= and DATABASE= arguments together in the INDCONN macro variable. |
specifies the schema name for the database.
Default | your default schema. To determine your default schema name, use the show search_path command from the Aster Client Tool (ACT). |
Restriction | The SCHEMA argument is valid only for Aster 4.6. For Aster 4.5, the scoring model XML files are published to the PUBLIC schema. |
Requirement | Any schema that is used must be in the search path. |
specifies the directory where the scoring model program, the properties file, and the format catalog are located.
Requirement | You must use a fully qualified pathname. |
Interaction | If you do not use the default filenames that are 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 that becomes part of the .ds2 and XML scoring filenames.
Restriction | The names of the .ds2 and XML scoring files are a combination of the model and type of filenames. A scoring filename cannot exceed 63 characters. For more information, see Aster Scoring Files. |
Requirement | The name must be a valid SAS name. 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 in the sasscore_modelname_io.xml file. For more information about the EM_ output variables, see Fixed Variable Names and Aster Scoring Files. |
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. |
Interactions | 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. |
The SAS file that is specified in the DATASTEP= argument is translated by the %INDAC_PUBLISH_MODEL macro into the sasscore_modelname.ds2 file. For Aster 4.5, this file is stored in the NC_INSTALLED_FILES table under the PUBLIC schema. For Aster 4.6, this file is stored in the NC_USER_INSTALLED_FILES table under the schema that you specified in the INDCONN macro variable. |
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 1660. | |
Interactions | 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. |
The XML file is renamed to sasscore_modelname_io.xml by the %INDAC_PUBLISH_MODEL macro. For Aster 4.5, this file is stored in the NC_INSTALLED_FILES table under the PUBLIC schema. For Aster 4.6, this file is stored in the NC_USER_INSTALLED_FILES table under the schema that you specified in the INDCONN macro variable. |
specifies the name of an Aster database to which the scoring functions and formats are published.
Restriction | If you specify DSN= in the INDCONN macro variable, do not use the DATABASE argument. |
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 %INDAC_PUBLISH_MODEL Macro Run Process. |
Tip | You can publish the scoring files to a shared database where other users can access them. |
specifies the name of the format catalog file. The file 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 the sasscore_modelname.ds2, sasscore_modelname_io.xml, and sasscore_modelname_ufmt.xml files.
overwrites the current sasscore_modelname.ds2, sasscore_modelname_io.xml, and sasscore_modelname_ufmt.xml files, if those files by the same name are already registered.
causes the sasscore_modelname.ds2, sasscore_modelname_io.xml, and sasscore_modelname_ufmt.xml files to be dropped from either the NC_INSTALLED_FILES table (Aster 4.5) or the NC_USER_INSTALLED_FILES table (Aster 4.6) in the database.
Default | CREATE |
Tip | If the scoring files have been previously defined and you specify ACTION=CREATE, you receive warning messages from Aster. If the scoring files have been previously defined and you specify ACTION=REPLACE, no warnings are issued. |
specifies a directory that contains diagnostic files.
Tip | This argument is useful to debug a scoring model that fails to be published. |
See | Special Characters in Directory Names |
%let indconn = server=yoursvr user=user1 password=open1 database=yourdb schema=yoursch; %indac_publish_model( dir=C:\SASIN\score, modelname=score);