The Essential PROC SQL Handbook for SAS Users

by Katherine Prairie

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.

588 pages, Paperback

First published May 19, 2005

About the author

Katherine Prairie brings her own experience as an international geologist to the Alex Graham thriller series. Her debut novel THIRST was shortlisted for the Whistler Independent Book Awards and BLUE FIRE was shortlisted for the International Rubery Book Awards and a semi-finalist in the Adventure Writers Competition. She is an award-winning presenter, the co-founder of Sisters in Crime - Canada West, and a past Crime Writers of Canada director. An avid traveller with an insatiable curiosity, you never know where you’ll find her next! But most days, she’s in Kingston, Canada quietly plotting murder and mayhem under the watchful eye of a cat.