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 files or functions are created and registered for use in SQL queries.

The following figure illustrates this process.

Process Flow Diagram

Note: This is a one-time installation process.

1	Install the components that are necessary for in-database processing. The components that are deployed are different for each database. For more information, see the SAS In-Database Products: Administrator's Guide. Note: This is a one-time installation process.
2	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 or functions to a score output directory. For more information, see Exporting the Scoring Model Files from SAS Enterprise Miner.
3	Start SAS 9.3 and run the SAS publishing macros. This creates the files that are needed to build the scoring files or 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.
4	After the scoring files or functions are created, you can run your scoring model. For more information, see the topic on running the scoring model in the Scoring Accelerator chapter for your database.