In-Database Processing of Base Procedures

Base Procedures That Are Enhanced for In-Database Processing

In the third maintenance release for SAS 9.2, Base SAS procedures have been enhanced so they can process data inside the Teradata Enterprise Data Warehouse (EDW), DB2 under UNIX, and Oracle. The in-database procedures are used to generate more sophisticated queries that allow the aggregations and analytics to be run inside the database. These in-database procedures all generate SQL queries. You use SAS/ACCESS or SQL as the interface to the Teradata EDW.

The following Base SAS procedures have been enhanced for in-database processing.

In-Database Base Procedures
Procedure		Description
PROC FREQ in Base SAS Procedures Guide: Statistical Procedures		produces one-way to n-way tables; reports frequency counts; computes test and measures of association and agreement for two-way to n-way crosstabulation tables; can compute exact tests and asymptotic tests; can create output data sets.
PROC MEANS		computes descriptive statistics; can produce printed output and output data sets. By default, PROC MEANS produces printed output.
PROC RANK		computes ranks for one or more numeric variables across the observations of a SAS data set; can produce some rank scores.
PROC REPORT		combines features of the PRINT, MEANS, and TABULATE procedures with features of the DATA step in a single report-writing tool that can produce a variety of reports.
PROC SORT		orders SAS data set observations by the values of one or more character or numeric variables.
PROC SUMMARY		computes descriptive statistics; can produce a printed report and create an output data set. By default, PROC SUMMARY creates an output data set.
PROC TABULATE		displays descriptive statistics in tabular format, using some or all of the variables in a data set.

For more information, see the documentation for each procedure and "Overview of In-Database Procedures" in SAS/ACCESS for Relational Databases: Reference.

Top of Page