macro indnzpm not defined
Tip | Use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error to occur. |
Requirement | 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 |
Restriction | The scoring function name is a combination of the model and output variable names. A scoring function name cannot exceed 128 characters. For more information, see Scoring Function Names. |
Requirement | The model name must be a valid SAS name that is ten characters or fewer. 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 Netezza scoring functions. For more information about the EM_ output variables, see Fixed Variable Names and Scoring Function Names. |
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. |
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 128. | |
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. |
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 %INDNZ_PUBLISH_MODEL Macro Run Process. |
Tip | You can publish the scoring functions and formats to a shared database where other users can access them. |
Default | SASLIB |
See | For more information about publishing the SAS_COMPILEUDF function, see the SAS In-Database Products: Administrator's Guide. |
Default | SASLIB |
Default | |
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. |
Default | CREATE |
Tip | If the function was published previously and you specify ACTION=CREATE, you receive warning messages that the function already exists and you are prompted to use REPLACE. If you specify ACTION=DROP and the function does not exist, an error message is issued. |
Default | FENCED |
Restriction | The MODE= argument is supported for Netezza 6.0. The MODE argument is ignored for previous versions of Netezza. |
Tip | There are limited resources available in Netezza when you run in fenced mode. For example, there is a limit to the number of columns available. |
See | Modes of Operation |
Default | UPPERCASE |
Tip | When you specify the IDCASE argument, the %INDNZ_PUBLISH_MODEL macro first determines which release of Netezza is being used. If Netezza release 5.0 or later is being used, the macro then checks to see whether the LOWERCASE or UPPERCASE option is set for the database by using SQL statement SELECT IDENTIFIER_CASE. If the value of the IDCASE argument is different from the case configuration of the database, the macro overwrites the value of the IDCASE option and uses the case configuration of the database. If an earlier release of Netezza is being used, the macro uses the value of the IDCASE argument. |
See | Using the Scoring Functions for more information about the SampleSQL.txt file |
Tip | This argument is useful when testing your scoring models. |
See | Special Characters in Directory Names |
%indnzpm; %let indconn = server=netezbase user=user1 password=open1 database=mydb; %indnz_publish_model(dir=C:\SASIN\baseball1, modelname=baseball1);
CREATE FUNCTION baseball1_EM_eventprobablility ( "CR_ATBAT" float, "CR_BB" float, "CR_HITS" float, "CR_HOME" float, "CR_RBI" float, "CR_RUNS" float, "DIVISION" varchar(31), "LEAGUE" varchar(31), "NO_ASSTS" float, "NO_ATBAT" float, "NO_BB" float, "NO_ERROR" float, "NO_HITS" float, "NO_HOME" float, "NO_OUTS" float, "NO_RBI" float, "NO_RUNS" float, "YR_MAJOR" float ) RETURNS float LANGUAGE CPP PARAMETER STYLE npsgeneric CALLED ON NULL INPUT EXTERNAL CLASS NAME 'Cbaseball1_em_eventprobability' EXTERNAL HOST OBJECT '/tmp/tempdir_20090506T113450_316550/baseball1.o_x86' EXTERNAL NSPU OBJECT '/tmp/tempdir_20090506T113450_316550/baseball1.o_diab_ppc'; DEPENDENCIES dbjazlib..sas_jazlib /* if TwinFin system */