• Print  |
  • Feedback  |

Knowledge Base

Feedback

SAS In-Database Technology

SAS 9.3 In-Database Technology

SAS In-Database technology is a flexible, efficient way to leverage increasing amounts of data by integrating select SAS technology into databases or data warehouses. It utilizes the massively parallel processing (MPP) architecture of the database or data warehouse for scalability and better performance. Using SAS In-Database technology, you can run scoring models, some SAS procedures, and formatted SQL queries inside the database.

The documentation for the SAS Scoring Accelerator, in-database procedures, format publishing, and the SAS_PUT() function has been consolidated into the following user's guide and an administrator's guide.

  • SAS 9.3 In-Database Products: User's Guide, Fourth Edition
    PDF (4.67MB)   |   HTML
  • SAS 9.3 In-Database Products: Administrator's Guide, Fourth Edition
    PDF (2.20MB)   |   HTML

Related Documentation

  • Scoring Accelerator System Requirements [HTML]
  • In-Database Products: Platform Support Matricies [PDF] (416KB)
  • SAS/ACCESS for Relational Databases: Reference, Second Edition [HTML]
  • SAS Model Manager (Teradata, DB2, and Netezza only) [HTML]
  • SAS Enterprise Miner [HTML]
  • Base SAS Procedure's Guide, Second Edition [HTML]
  • Base SAS Procedure's Guide: Statistical Procedures, Second Edition [HTML]
  • SAS/STAT User's Guide [HTML]
  • SAS Analytics Accelerator for Teradata [HTML]

Technical Papers

  • SAS Scoring Accelerator for DB2 (SGF 2011) [PDF] (425KB)
  • SAS Presents In-Database Procedures in Practice (SGF 2010) [PDF] (262KB)
  • Rapid Predictive Modeling for Customer Intelligence (SGF 2010) [PDF] (723KB)
  • SAS Data Integration Studio Tips & Techniques for Implementing ELT (SGF 2010) [PDF] (1024KB)
  • SAS and Teradata: Accelerating the Power to Know (SGF 2009) [PDF] (276KB)
  • In-Database Procedures with Teradata: How They Work and What They Buy You (SGF 2009) [PDF] (267KB)
  • Publish SAS®Formats in Your Teradata Server (SGF 2009) [PDF] (152KB)

SAS 9.2 In-Database Technology

SAS Scoring Accelerator

  • SAS Scoring Accelerator for Aster nCluster [HTML]
  • SAS Scoring Accelerator for DB2 [HTML]
  • SAS Scoring Accelerator for Greenplum [HTML]
  • SAS Scoring Accelerator for Netezza [HTML]
  • SAS Scoring Accelerator for Teradata [HTML]

Related Documentation

  • Scoring Accelerator System Requirements [HTML]
  • SAS In-Database Products: Administrator's Guide
    PDF (580KB)  |   HTML
  • SAS Model Manager (Teradata only) [HTML]

In-Database Procedures

SAS/ACCESS 9.2 for Relational Databases: Reference

  • In-Database Procedures in Teradata [HTML]
  • SQLGENERATION= LIBNAME option [HTML]
  • SQLGENERATION= system option [HTML]

Base SAS Procedures

  • Base Procedures That Are Enhanced for In-Database Processing [HTML]
  • In-Database Computation (PROC FREQ) [HTML]
  • PROC FREQ [HTML]
  • PROC MEANS [HTML]
  • PROC RANK [HTML]
  • PROC SUMMARY [HTML]

SAS/STAT Procedures

Format Publishing and the SAS_PUT Function

SAS/ACCESS 9.2 for Relational Databases: Reference

  • Deploying and Using SAS Formats in Teradata [HTML]
  • Deploying and Using SAS Formats in Netezza [HTML]
  • SQLMAPPUTTO= system option [HTML]