Overview

Introduction

SAS provides a variety of techniques for querying data. In this chapter, you learn to select the most efficient query techniques from those listed below, based on comparisons of resource usage.
Task
Techniques
selecting a subset
  • WHERE statement that references an indexed data set
creating a detail report
  • PRINT procedure
  • SQL procedure
creating a summary report with one or more class variables
  • MEANS procedure (or SUMMARY procedure)
  • TABULATE procedure
  • REPORT procedure
  • SQL procedure
  • DATA step
Note: This chapter does not cover the SAS Scalable Performance Data Engine (SAS SPD Engine). For details about using the SAS SPD Engine to improve performance, ...

Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial