The Essential PROC SQL Handbook for SAS® Users Reviews
"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
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 Bechtold, SAS user
"I think this book is very interesting and educational. It has a logical progression that would fit well as an educational textbook. I may add this book to the curriculum, but would definitely recommend it as another reference textbook for my DBA program."
Mark Perry, Oracle Database Administrator
Southern Alberta Institute of Technology (SAIT)
"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
SAIT (Southern Alberta Institute of Technology)
"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