Contents
About
Title Page
What’s New in SAS 9.3 In-Database Products
Introduction
SAS In-Database Processing
Introduction to SAS In-Database Processing
Deployed Components for In-Database Processing
User-Defined Functions and the SAS Embedded Process
Where to Go from Here
SAS Scoring Accelerator
Introduction to the SAS Scoring Accelerator
Overview of the SAS Scoring Accelerator
How It Works
Special Characters in Directory Names
Exporting the Scoring Model Files from SAS Enterprise Miner
Overview of the Score Code Export Node
Comparing the Score Code Export Node with Registering Models on the SAS Metadata Server
Using the Score Code Export Node
Output Created by the Score Code Export Node
SAS Scoring Accelerator for Aster nCluster
Publishing Scoring Model Files in Aster nCluster
Running the %INDAC_PUBLISH_MODEL Macro
Scoring Files and Functions inside the Aster nCluster Database
SAS Scoring Accelerator for DB2 under UNIX
Overview of Running Scoring Models in DB2
Using Scoring Functions to Run Scoring Models
Using the SAS Embedded Process to Run Scoring Models
Running the %INDB2_PUBLISH_MODEL Macro
DB2 Permissions
SAS Scoring Accelerator for Greenplum
Publishing Scoring Model Files in Greenplum
Running the %INDGP_PUBLISH_MODEL Macro
Greenplum Permissions
Scoring Functions inside the Greenplum Database
SAS Scoring Accelerator for Netezza
Publishing Scoring Model Files in Netezza
Running the %INDNZ_PUBLISH_MODEL Macro
Scoring Functions inside the Netezza Data Warehouse
SAS Scoring Accelerator for Oracle
Overview of Running Scoring Models
Oracle Permissions
How to Run a Scoring Model in Oracle
Creating a Model Table
Running the %INDOR_PUBLISH_MODEL Macro
Viewing the Scoring Files
SASEPFUNC Table Function
SAS Scoring Accelerator for Teradata
Overview of Running Scoring Models in Teradata
Using Scoring Functions to Run Scoring Models
Using the SAS Embedded Process to Run Scoring Models
Running the %INDTD_PUBLISH_MODEL Macro
Teradata Permissions
SAS Scoring Accelerator and SAS Model Manager
Using the SAS Scoring Accelerator with SAS Model Manager
Format Publishing and the SAS_PUT( ) Function
Deploying and Using SAS Formats inside the Database
Using SAS Formats and the SAS_PUT( ) Function
How It Works
Special Characters in Directory Names
Considerations and Limitations with User-Defined Formats
Tips for Using the Format Publishing Macros
Tips for Using the SAS_PUT( ) Function
Determining Format Publish Dates
Deploying and Using SAS Formats in Aster nCluster
User-Defined Formats in the Aster nCluster Database
Publishing SAS Formats in Aster nCluster
Aster nCluster Format Files
Using the SAS_PUT( ) Function in the Aster nCluster Database
Aster nCluster Permissions
Deploying and Using SAS Formats in DB2 under UNIX
User-Defined Formats in the DB2 Database
Publishing SAS Formats in DB2
Using the SAS_PUT( ) Function in the DB2 Database
DB2 Permissions
Deploying and Using SAS Formats in Greenplum
User-Defined Formats in the Greenplum Database
Publishing SAS Formats in Greenplum
Using the SAS_PUT( ) Function in Greenplum
Greenplum Permissions
Deploying and Using SAS Formats in Netezza
User-Defined Formats in the Netezza Data Warehouse
Publishing SAS Formats in Netezza
Using the SAS_PUT( ) Function in the Netezza Data Warehouse
Netezza Permissions
Deploying and Using SAS Formats in Teradata
User-Defined Formats in the Teradata EDW
Publishing SAS Formats in Teradata
Data Types and the SAS_PUT( ) Function
Using the SAS_PUT( ) Function in the Teradata EDW
Teradata Permissions
In-Database Procedures
Running SAS Procedures inside the Database
Introduction to In-Database Procedures
Running In-Database Procedures
In-Database Procedures in Aster nCluster, DB2 under UNIX and PC Hosts, Greenplum, Netezza, and Oracle
In-Database Procedures in Teradata
In-Database Procedure Considerations and Limitations
Using the MSGLEVEL Option to Control Messaging
System Options Reference
System Options That Affect In-Database Processing
SQLGENERATION= System Option
SQLMAPPUTTO= System Option
SQLREDUCEPUT= System Option
Appendix
Scoring File Examples
Example of a .ds2 Scoring File
Example of an Input and Output Variables Scoring File
Example of a User-Defined Formats Scoring File
Recommended Reading
Product
Release
DATA Step to DS2 Translator
2.53
Base SAS
9.3_M1
SAS Score Publishing Agent for Oracle
4.1
SAS Scoring Accelerator for Oracle
Type
Usage and Reference
Copyright Date
October 2011
Last Updated
05Jun2012