• 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


ProductRelease
DATA Step to DS2 Translator2.53
Base SAS9.3_M1
SAS Score Publishing Agent for Oracle4.1
SAS Scoring Accelerator for Oracle
Type
Usage and Reference
Copyright Date
October 2011
Last Updated
05Jun2012