Resources

SAS® 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 uses 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. With Greenplum, Hadoop, and Teradata, you can also execute DS2 thread programs in parallel inside the database. With Hadoop and Teradata, you can perform data quality operations and extract and transform data.

9.4 (Maintenance 5 September 2017)

9.4 (Maintenance 4 November 2016)

  • SAS 9.4 In-Database Products: User's Guide, Seventh Edition PDF | HTML
  • SAS 9.4 In-Database Products: Administrator's Guide, Eighth Edition PDF | HTML

9.4 (Maintenance 3 January 2016)

  • SAS 9.4 In-Database Products: User's Guide, Sixth Edition PDF | HTML
  • SAS 9.4 In-Database Products: Administrator's Guide, Seventh Edition PDF | HTML

9.4 (Maintenance 3)

  • SAS 9.4 In-Database Products: User's Guide, Sixth Edition PDF | HTML
  • SAS 9.4 In-Database Products: Administrator's Guide, Sixth Edition PDF | HTML

9.4

  • SAS 9.4 In-Database Products: User's Guide, Fifth Edition  PDF  |  HTML
  • SAS 9.4 In-Database Products: Administrator's Guide, Fifth Edition  PDF  |  HTML

Related Documentation

Technical Papers

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  |  HTML
  • SAS 9.3 In-Database Products: Administrator's Guide, Fourth Edition  PDF  |  HTML
Related Documentation

Technical Papers

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

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