Transcription of SUGI 23: Intermediate PROC SQL - SAS
{{id}} {{{paragraph}}}
Example: marketing
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 .. 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/ACCESS software provides interfaces for many popular illustrative examples used in this paper are based upona simplified, hypothetical personnel data base for a fictitiouscompany. It should not be identified with any data basewhich actually is used by the State of Texas, or any of itsagencies.
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
Using eg effectively, Pass, Through, Select, DATA Step vs. PROC SQL: What, Ten Things you May Miss in, Native SQL Stored Procedures, SQL to pass, Database Connectivity Toolset User Manual, National Instruments, LabVIEW Database Connectivity Toolkit User, Database Connectivity Toolkit User Manual, Of COMPUTER OPERATOR AND PROGRAMMING ASSISTANT, ORACLE: A HOW-TO GUIDE FOR PL/SQL USERS