Previous Page | Next Page

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.
computes descriptive statistics; can produce printed output and output data sets. By default, PROC MEANS produces printed output.
computes ranks for one or more numeric variables across the observations of a SAS data set; can produce some rank scores.
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.
orders SAS data set observations by the values of one or more character or numeric variables.
computes descriptive statistics; can produce a printed report and create an output data set. By default, PROC SUMMARY creates an output data set.
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.

Previous Page | Next Page | Top of Page