Transcription of 127-29: Efficiency Techniques for Beginning PROC SQL Users
{{id}} {{{paragraph}}}
Paper 127-29 Efficiency Techniques for Beginning PROC SQL Users Kirk Paul Lafler, Software Intelligence Corporation Abstract PROC SQL provides SAS Users with a powerful programming language that can rival DATA step coding Techniques either in terms of the processing time or the human time involved to write the code. Attendees of this hands-on workshop will learn how to use PROC SQL statements, options, and clauses to conserve CPU, I/O, and memory resources while accomplishing tasks involving processing, ordering, grouping, and summarizing data.
The simplest of requests can fall prey to one or more efficiency violations, such as retaining unwanted tables in work space, not subsetting early to eliminate undesirable records, or reading wanted as well as unwanted variables.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}
Classroom Progress-Monitoring Methods Checklist, Common Core English Language Arts and Mathematics, Checklist, Instructions for Continued Airworthiness - ICA, For Instructional Planning and Collegial, For Instructional Planning and Collegial Learning, Divisions for Special Education Services and Supports, The ACT Test, The ACT ® Test, Early learning and development Standards