Introduction

This section shows you how to do the following:

• use PROC SQL options to create and debug queries

• improve query performance

• explain 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).

Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.