The Essential PROC SQL Handbook for SAS Users


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 Essential PROC SQL Handbook for SAS Users is a well-organized, well-thought out, and very handy reference guide. It is a veritable tome for SQL usage in SAS, a must-have for any SAS user who pulls data from relational tables.

Robert Schroko
VP Database Marketing/CRM, Saks Fifth Avenue

What a versatile book! It’s a tutorial for SAS users that have never used SQL. It’s a step-by-step guide for programmers that need to convert existing SQL code into SAS PROC SQL. It is also a resource that any experienced SAS user will find invaluable. Even those who have been using PROC SQL for years can improve their code efficiency and sophistication by spending just a short amount of time with this handbook.

Meredith Sterling
SAS User

Katherine has taken an industry-wide requirement for SAS and contributed a much desired reference from which users, beginner to guru, will profit. She has expertly taken a complex subject and simplified it in step-by-step format while satisfying us with understandable examples. I found her approach appropriate, straight forward and undemanding to comprehend…, I strongly advocate this superior manuscript for use in training as well as employing SAS.

Greg H. Smith, OCP DBA

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.

Sean O’Neill
Citi Cards, Information Business


SAS Institute