Explore the Power of PROC SQL
Navigate the world of the powerful SQL procedure with The Essential PROC SQL Handbook for SAS Users. Written in an easy-to-use logical format, this comprehensive reference focuses on the functionality of the SQL procedure as well as the accomplishment of common tasks using PROC SQL, enabling readers to quickly develop and enhance their SQL skills.
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.
- Over 300 examples of PROC SQL code plus queries and diagrams showing how the statements are processed.
- Tips and techniques highlighting “need-to-know” concepts.
- An appendix designed specifically for SQL Pass-Through Facility and SAS/ACCESS users.
The section in Chapter 6 on the SQL optimizer and use of indexes in queries is a perfect example of an often difficult concept for analysts to understand (and thus, often overlooked), yet critical to writing efficient code. SQL optimization and proper use of indexes is important for analysts and programmers to understand when working with large data volumes in a data warehouse environment. The book presents the optimizer and indexing to pics clearly, with good query examples and how to interpret SAS logs… What Katherine illustrates in her book is how powerful and important PROC SQL is to SAS and that it can often be more efficient to use than other SAS code when performing database tasks.
The Essential PROC SQL Handbook for SAS Users is the ideal reference for a SQL programmer (novice to expert) new to working in the SAS environment. This book will be the single source reference for PROC SQL within our Data Quality group.
Buy your copy today