Programming with the SQL Procedure

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