The SAS publishing macros
are used to publish the user-defined formats and the scoring functions
in Netezza.
The %INDNZ_PUBLISH_MODEL
macro creates the files that are needed to build the scoring functions
and publishes those files to a specified database in the Netezza data
warehouse. Only the EM_ output variables are published as Netezza
scoring functions.
For more information
about the EM_ output variables, see Fixed Variable Names.The %INDNZ_PUBLISH_MODEL
macro uses some of the files that are created by the SAS Enterprise
Miner Score Code Export node: the scoring model program (score.sas
file), the properties file (score.xml file), and (if the training
data includes SAS user-defined formats) a format catalog.
The %INDNZ_PUBLISH_MODEL
macro performs the following tasks:
-
takes the score.sas and score.xml
files that are created using the Score Code Export node and produces
the set of .c, .cpp, and .h files that are necessary to build separate
scoring functions for each of a fixed set of quantities that can be
computed by the scoring model code
-
if a format catalog is available,
processes the format catalog and creates an .h file with C structures,
which are also necessary to build the scoring functions
-
produces a script of the Netezza
commands that are necessary to register the scoring functions on the
Netezza data warehouse
-
transfers the .c, .cpp,
and .h files to Netezza using the Netezza External Table interface
-
calls the
SAS_COMPILEUDF function
to compile the source files into object files and to access the SAS
formats library
-
uses the
SAS/ACCESS Interface to
Netezza to run the script to create the scoring functions with the
object files