SAS In-Database Technologies

SAS^® In-Database Technologies

Shorten the time needed for data quality and analytical processes by performing them within the database. Our in-database technologies leverage increasing amounts of data by integrating select SAS technology into databases or data warehouses. Run scoring models, some SAS procedures and formatted SQL queries inside the database.

Most recent releases:

SAS^® In-Database Technologies in SAS^® Viya

SAS^® In-Database Technologies on SAS 9.4M7

Documentation

Find user's guides and other technical documentation for SAS In-Database Technology.

SAS Viya and SAS 9.4

SAS Viya

SAS 9.4 (Maintenance 7 - August 2020)

Previous Versions

Viya 3.5 and SAS 9.4

9.4

SAS 9.4 (Maintenance 6 November 2018)

9.4 (Maintenance 5 July 2018)

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

9.3

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

9.2

SAS In-Database Products: Administrator's Guide PDF | HTML
SAS Scoring Accelerator
SAS Model Manager (Teradata only)

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

SAS Analytics Accelerator for Teradata
PROC PRINCOMP HTML
PROC REG HTML
PROC SCORE HTML
PROC VARCLUS HTML

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

SAS Technical Papers

Read technical papers to learn how to complete a task or achieve a goal.

SAS In-Database Processing in Teradata DBMS

Exploring SAS Embedded Process Technologies on Hadoop (SAS Global Forum 2016)

SAS Model Manager: An Easy Way for Deploying SAS Analytical Models to Databases and Hadoop (SAS Global Forum 2015)

Introduction to SAS Data Loader: The Power of Data Transformation in Hadoop (SAS Global Forum 2015)

Now That You Have Your Data in Hadoop, How Are You Staging Your Analytical Base Tables? (SAS Global Forum 2015)