How It Works

Using SAS Enterprise Miner, you can generate SAS DATA step code that contains scoring functions. The SAS Scoring Accelerator takes the scoring model code, the associated property file that contains model inputs and outputs, and a catalog of user-defined formats. The SAS Scoring Accelerator deploys (or publishes) them to the database. Inside the database, one or more scoring functions are created and registered for use in SQL queries. Figure 1.1 illustrates this process.

Process Flow Diagram

1Install the components that are necessary for in-database processing.

For more information, see the SAS In-Database Products: Administrator's Guide.

Note: This is a one-time installation process.

2Use SAS Enterprise Miner to create a scoring model, and use the Score Code Export node to export files that are used to create the scoring functions to a score output directory.

For more information, see Exporting the Scoring Model Files from SAS Enterprise Miner.

3Start SAS 9.3 and run the SAS publishing macros. This creates the files that are needed to build the scoring files and functions and publish those files to the database.

For more information, see the section on publishing scoring model files in the Scoring Accelerator chapter for your database.

4After the scoring functions are created, they are available to use in any SQL expression in the same way that the database’s built-in functions are used.

For more information, see the topic on scoring functions inside the database in the Scoring Accelerator chapter for your database.