SUGI 23: Intermediate PROC SQL - SAS

1 Intermediate PROC SQLT homas 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.

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

Loading..

Tags:

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

Information

Related search queries