Transcription of SUGI 23: Intermediate PROC SQL - SAS
{{id}} {{{paragraph}}}
Example: bachelor of science
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.
3 job assignment number and calculated duration of employment.) We use an ORDER BY clause to return the results of a query in ascending (the default), or in descending order,
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: