macro indgppm not defined
Tip | Use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error. |
Requirement | You must specify either the DSN= argument or the SERVER= and DATABASE= arguments in the INDCONN macro variable. |
Requirement | You must specify either the DSN= argument or the SERVER= and DATABASE= arguments in the INDCONN macro variable. |
Requirement | You must specify either the DSN= argument or the SERVER= and DATABASE= arguments in the INDCONN macro variable. |
Tip | If you do not specify a value for the SCHEMA argument, the value of the USER argument is used as the schema name. The schema must be created by your database administrator. |
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 63 characters. For more information, see Scoring Function Names. |
Requirement | The model name must be a valid SAS name that is 10 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 Greenplum 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. |
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 %INDGP_PUBLISH_MODEL Macro Run Process. |
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 has been previously defined and you specify ACTION=CREATE, you receive warning messages from Greenplum. If the function has been previously defined and you specify ACTION=REPLACE, no warnings are issued. |
Tip | This argument is useful when testing your scoring models. |
See | Special Characters in Directory Names |
%indgppm; %let indconn = user=user1 password=open1 dsn=green6 schema=myschema; %indgp_publish_model(dir=C:\SASIN\baseball1, modelname=baseball1, outdir=C:\test);
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 varchar(33) AS '/usr/local/greenplum-db-3.3.4.0/lib/postgresql/SAS/sample_dbitest_homeeq_5.so', 'homeeq_5_em_classification'