SAS^® In-Database processing enables several Base SAS Procedures to run inside one of several supported databases. This means that very large database files do not need to be transferred to enable SAS to do the analysis. In some cases, the Base SAS procedure syntax is converted to SQL procedure syntax that will use implicit pass-through to run inside the database. In other cases, native SQL is generated from the Base SAS procedure and it runs inside the database using explicit pass-through.

Supported databases as of SAS 9.2(TS2M3) are:
    Teradata, Oracle, DB2 running on Unix servers

The following link shows procedures enhanced for In-Database Processing and the DBMS supported: Procedures enhanced for In-Database Processing

To enable In-Database Processing, in addition to specifying the database engine on the LIBNAME statement, you should also specify SQLGENERATION=DBMS on the LIBNAME statement or as a global system option.

   libname test teradata server=xxxx user=xxxx password=xxxx
   sqlgeneration=dbms;  

                                 
The following system options will provide additional information in the SAS log about the In-Database Processing:

   options msglevel=i sastrace=',,,d' sastraceloc=saslog;

Base SAS® Software Procedures that Support SAS® In-Database Processing

Base Procedures	Starting SAS® Release	Not Supported
FREQ	9.2 TS2M2	ORDER=DATA
RANK	9.2 TS2M2	TIES=CONDENSE (in Oracle DBMS) Formatted BY variables
REPORT	9.2 TS2M3	DISPLAY/ORDER variables Statistics: MODE, PCTN, PCTSUM, quantile statistics*, hypothesis testing statistics** WEIGHT for CSS, USS, VAR, STD, STDERR, CV
SUMMARY/MEANS	9.2 TS2M2	Statements: FREQ, ID, IDMIN, IDMAX, IDGROUPS Statistics: KURT, MODE, SKEW, quantile statistics*, hypothesis testing statistics** WEIGHT for CSS, USS, VAR, STD, STDERR, CV, UCLM, LCLM, CLM
TABULATE	9.2 TS2M3	Statements: FREQ Statistics: all PCTN and PCTSUM statistics, KURT, MODE, SKEW, quantile statistics*, hypothesis testing statistics**
*  Quantile statistics include: P1, P5, P10, P25/Q1, P50/MEDIAN, p75/Q3, P90, P95, P99, QRANGE ** Hypothesis testing statistics include: PRT/PROBT, T

 

Considerations/Limitations that apply to all procedures:

• BY statement with NOTSORTED option prevents In-Database Processing
• In-Database has no obligation to maintain row order - DBMS tables have no inherent order for the rows
• OBS=, FIRSTOBS=, RENAME= prevent In-Database Processing

The following LIBNAME statement options prevent In-Database Processing:

• DBMSTEMP=YES
• DBCONINIT
• DBCONTERM
• DBGEN_NAME=SAS
• PRESERVE_COL_NAMES=NO
• PRESERVE_TAB_NAMES=NO
• PRESERVE_NAMES=NO
• MODE=TERADATA
• Libname concatenation

For more information about how a specific procedure works inside the database, see the documentation for the individual procedure. The SAS/ACCESS documentation for each database includes specific sections about In-Database Processing.