In-Database Processing of Base Procedures |
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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.