Transcription of SUGI 23: Intermediate PROC SQL
{{id}} {{{paragraph}}}
Example: air traffic controller
SUGI 23: Intermediate PROC SQL
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 .. 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.
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:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
SQL Tutorial, Oracle GoldenGate Hands-on Tutorial, Tutorial, Tutorial SQL, Structured Query Language, MERGING vs. JOINING: Comparing the DATA Step, SAS SQL, Informix Guide to SQL: Syntax, Informix Guide to SQL Syntax, SQL Facts SQL stands for Structured Query Language, SQL Facts SQL stands for Structured Query Language SQL, 30: Merging versus Joining: Comparing the