SAS Scoring Accelerator for SPD Server

Overview of the SAS Scoring Accelerator for SPD Server

The SAS Scoring Accelerator for SPD Server embeds the robustness of SAS Enterprise Miner scoring models directly in the highly scalable SPD Server. By using the SAS In-Database technology and the SAS Scoring Accelerator, the scoring process is done inside the SPD Server.

The SAS Scoring Accelerator for SPD Server takes the models that are developed by SAS Enterprise Miner and creates SPD server tables.

The SAS Scoring Accelerator consists of three components:

the Score Code Export node in SAS Enterprise Miner. This extension exports the model scoring logic (including metadata about the required input and output variables) from SAS Enterprise Miner.
a scoring publishing macro. This macro translates the scoring model into two or three SPD server tables that are needed to run the scoring model.
a run model macro. This macro takes the SPD Server tables that are produced by the scoring publishing macro and an input data table and runs the scoring model. This macro produces an SPD Server table that contains the output from the scoring model.

How It Works for SAS SPD Server

Using SAS Enterprise Miner, you can generate SAS DATA step code. The SAS Scoring Accelerator for SPD Server takes the scoring model code, the associated property file that contains model inputs and outputs, and, if needed, a catalog of user-defined formats. The SAS Scoring Accelerator for SPD Server deploys (or publishes) them to the SPD Server. Inside the SPD Server, SPD Server tables are created and used to run the scoring model. An output table that contains the results is created.

Note: Only the installation of Base SAS and SAS Scalable Performance Data Server is required for the in-database processing.

The following figure illustrates this process.

Process Flow Diagram for SAS Scoring Accelerator for SPD Server

1	Use SAS Enterprise Miner to create a scoring model. Use the Score Code Export node to export files that are used to create the scoring files and catalog to a score output directory. For more information, see Exporting the Scoring Model Files from SAS Enterprise Miner.
2	Start SAS and run the publish model macro. This macro creates the SPD Server tables that are needed to run the scoring model. For more information, see Running Scoring Models in SPD Server and %INDSP_PUBLISH_MODEL Macro Syntax.
3	Run the run model macro. This macro runs the scoring model and creates an output table. For more information, see Running Scoring Models in SPD Server and %INDSP_PUBLISH_MODEL Macro Syntax.
4	Use PROC SQL to query the output table data. For more information, see Scoring Output.