• Contents
  • About
  • What’s New in SAS 9.4 In-Database Products: User’s Guide
  • Introduction
    • SAS In-Database Processing
      • Introduction to SAS In-Database Processing
      • Deployed Components for In-Database Processing
      • Where to Go from Here
  • SAS Scoring Accelerator
    • Introduction to the SAS Scoring Accelerator
      • SAS Scoring Accelerator for SAS/ACCESS Databases
      • SAS Scoring Accelerator for SPD Server
      • Scoring with User-Defined Functions and the SAS Embedded Process
      • Considerations When Creating or Modifying DATA Step Score Code
      • Special Characters in Directory Names
    • Exporting the Scoring Model Files from SAS Enterprise Miner
      • Overview of the Score Code Export Node
      • Score Code Export Node Comparison
      • Using the Score Code Export Node in a Process Flow Diagram
      • Output Created by the Score Code Export Node
    • Analytic Store Scoring
      • Introduction to Analytic Store Scoring
      • How to Generate Analytic Store Scoring Files for the SAS Scoring Accelerator
    • SAS Scoring Accelerator for Aster
      • Overview of Running Scoring Models in Aster
      • Running the %INDAC_PUBLISH_MODEL Macro
      • Scoring Files and Functions inside the Aster 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
      • Overview of Running Scoring Models in Greenplum
      • Using Scoring Functions to Run Scoring Models
      • Using the SAS Embedded Process to Run Scoring Models
      • Running the %INDGP_PUBLISH_MODEL Macro
      • Greenplum Permissions
    • SAS Scoring Accelerator for Hadoop
      • Overview of Running Scoring Models in Hadoop
      • Running Scoring Models in Hadoop
      • INDCONN Macro Variable
      • %INDHD_PUBLISH_MODEL Macro Syntax
      • %INDHD_RUN_MODEL Syntax
      • Creating a Metadata File for the Input Data File
      • Scoring Output
      • Reading and Writing HCatalog File Types
      • Using the MapReduce Job Logs to View DS2 Error Messages
      • Hadoop Permissions
    • SAS Scoring Accelerator for Netezza
      • Overview of Running Scoring Models in Netezza
      • Using Scoring Functions to Run Scoring Models
      • Using the SAS Embedded Process to Run Scoring Models
      • INDCONN Macro Variable
      • Running the %INDNZ_PUBLISH_MODEL Macro
      • Netezza Permissions
    • 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
      • Oracle Scoring Files
      • SASEPFUNC Table Function
    • SAS Scoring Accelerator for SAP HANA
      • Overview of Running Scoring Models in SAP HANA
      • How to Run a Scoring Model in SAP HANA
      • INDCONN Macro Variable
      • Creating the Model Table
      • Running the %INDHN_PUBLISH_MODEL Macro
      • Running the %INDHN_RUN_MODEL Macro
      • Scoring Output
      • SAP HANA Permissions
    • SAS Scoring Accelerator for SPD Server
      • Overview of Running Scoring Models in SPD Server
      • Running Scoring Models in SPD Server
      • INDCONN Macro Variable
      • INDDATA Macro Variable
      • %INDSP_PUBLISH_MODEL Macro Syntax
      • %INDSP_RUN_MODEL Macro Syntax
      • Scoring Output
      • SPD Server Permissions
    • 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
  • SAS In-Database Code Accelerator
    • Using the SAS In-Database Code Accelerator
      • Overview of the SAS In-Database Code Accelerator
      • Requirements for Using the SAS In-Database Code Accelerator
      • SAS In-Database Code Accelerator for Greenplum
      • SAS In-Database Code Accelerator for Hadoop
      • SAS In-Database Code Accelerator for Teradata
      • Using the DS2ACCEL Option to Control In-Database Processing
      • BY-Group Processing When Running Thread Programs inside the Database
      • Considerations and Limitations
      • SAS In-Database Code Accelerator Examples
  • In-Database DATA Step Processing
    • DATA Step Processing in Hadoop
      • DATA Step Processing in Hadoop
      • Requirements for DATA Step Processing
      • Restrictions in DATA Step Processing
      • Example: DATA Step Program for Hadoop
  • 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
      • Format Publishing with User-Defined Functions and the SAS Embedded Process
      • 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
      • User-Defined Formats in the Aster Database
      • Publishing SAS Formats in Aster
      • Aster Format Files
      • Using the SAS_PUT( ) Function in the Aster Database
      • Aster 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
      • Procedures in Aster, DB2, Greenplum, Hadoop, HAWQ, Impala, Microsoft SQL Server, Netezza, Oracle, PostgreSQL, Redshift, SAP HANA, and Vertica
      • Procedures in Teradata
      • Procedure Considerations and Limitations
      • Running PROC TRANSPOSE inside the Database
      • Using the MSGLEVEL Option to Control Messaging
  • System Options Reference
    • System Options That Affect In-Database Processing
      • DSACCEL= System Option
      • 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
SAS In-Database Code Accelerator for Hadoop9.43
Type
Usage and Reference
Copyright Date
November 2016
Last Updated
22Nov2016