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, see the SAS documentation.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.12.107.31