Data Management

SAS Presents In-Database Base Procedures in Practice

Free registration required

Executive Summary

As part of the SAS In-Database Initiative, SAS has enhanced a series of Base SAS procedures (including FREQ, RANK, and SUMMARY/MEANS) to directly leverage descriptive statistical functions supported by the DBMS partners. These enhancements allow the procedures to drive work into the DBMS using SQL generation in order to greatly reduce or eliminate data transfer into SAS, while leveraging the scalability of parallel databases. This paper explains how one engages these capabilities in a SAS program, explains how one identifies when and what kind of in-database queries are passed to the DBMS, and provides some best practices on effectively using them. The discussion will include how these in-database-enabled procedures work on multiple DBMS platforms such as Teradata, Oracle, and DB2.

  • Format: PDF
  • Size: 261 KB