Introduction

This section shows you how to do the following:
  • use PROC SQL options to create and debug queries
  • improve query performance
  • access dictionary tables and how they are useful in gathering information about the elements of SAS
  • use PROC SQL with the SAS macro facility
  • use PROC SQL with the REPORT procedure
  • access DBMSs by using SAS/ACCESS software
  • format PROC SQL output by using the SAS Output Delivery System (ODS)