The Essential PROC SQL Handbook for SAS Users

Navigate the world of the powerful SQL procedure with Katherine Prairie's Essential PROC SQL Handbook for SAS Users. Written in an easy-to-use, logical format, this comprehensive reference focuses on the functionality of the procedure, as well as the accomplishment of common tasks using PROC SQL, enabling readers to quickly develop and enhance their SQL skills. Features include more than 300 examples of PROC SQL code, plus queries and diagrams showing how the statements are processed, tips and techniques highlighting "need-to-know" concepts, and an appendix designed specifically for SQL Pass-Through Facility and SAS/ACCESS users. This practical guide is written for SAS users of all levels who want to learn how to integrate the SQL procedure into their Base SAS and/or SAS/ACCESS programs as well as SQL programmers who want to adapt their current skills to SAS.

Katherine Prairie advises a broad range of clients throughout North America as a partner and senior systems project manager at Stone Country Solutions Ltd. She has extensive experience working in all major database systems and their associated SQL languages and has been using SAS since 1983 in areas as diverse as application development to complex scientific models and data mining projects. She successfully designed the Database Administration FastTrack program at the Southern Alberta Institute of Technology (SAIT) while teaching and writing many of the courses in the program and is also an accomplished author of numerous manuals and online help documents. Katherine has an M.Sc. in Chemical and Bio-Resource Engineering and is an Oracle Certified Professional DBA.