SUGI 23: Intermediate PROC SQL

← Back to document page

1Intermediate PROC SQLThomas J. Winn Jr., Texas State Comptroller's Office, Austin, TexasABSTRACTThis tutorial presentation will provide a practical explanationof some advanced features of the SAS SQL Procedure,including the use of: summary functions, subqueries,complex joins, in-line views, indexes, macro variables, andthe SQL Pass-Through Facility. Also included will be adiscussion of several useful tips for improving theperformance of PROC SQL queries. This paper is for SASprogrammers who already know how to code simpleSELECT ... FROM ... WHERE ... ORDER BY ... querystatements for PROC SQL, and who want to be able to presentation does not explain SAS/ACCESS concepts,nor the ACCESS, nor DBLOAD procedures. SAS/ACCESSsoftware provides interfaces for many popular illustrative examples used in this paper are based upona simplified, hypothetical personnel data base for a fictitiouscompany.

1 Intermediate PROC SQL Thomas J. Winn Jr., Texas State Comptroller's Office, Austin, Texas ABSTRACT This tutorial presentation will provide a practical explanation

  Corps, Intermediate, Sugi, Sugi 23, Intermediate proc sql