PROC SQL: Beyond the Basics Using SAS®, Third Edition

Just like a fine wine that gets better with age, it comes as no surprise that Kirk Lafler's third edition of PROC SQL: Beyond the Basics Using SAS® has also gotten better and is full of in-depth knowledge and experience. Packed with more tips and productive ideas, any new or experienced SAS programmer can quickly master the full power of PROC SQL.

I continue to depend on this book as my first choice for PROC SQL options and powerful features such as detail and summary information, queries, simple to complex joins, indexes, macro variables, metadata, and subqueries. The sample datasets and examples make these features easy to understand and apply. For more data transformations, there is a great section on data cleaning, filtering, de-duplication, and format revision.

Sunil Gupta
Director of Statistical Programming, Cytel


Just when you think you know everything about PROC SQL in SAS®, Kirk Lafler comes out with a new edition of his book, PROC SQL: Beyond the Basics Using SAS®, which is full of new and surprising ways to utilize PROC SQL.

In his usual straightforward writing style and easy-to-follow examples, Kirk knocks it out of the ball park with the third edition of PROC SQL: Beyond the Basics Using SAS®.  If you are new to programming in SAS or PROC SQL, this book has a ton of tried-and-true examples, techniques, and programming pearls of wisdom.  For advanced SAS programmers, Kirk has included new chapters on fuzzy matching and data-driven programming using PROC SQL that are sure to be a big hit. These chapters are full of advanced ways to utilize PROC SQL in your daily programming to tackle those hard programming tasks.  If you are interested in raising your skill set to the next level or want to make your code better, you need to have this book – you won't be disappointed.

Toby Dunn
SAS Programmer


Kirk Lafler continues to wow me with his style of explaining PROC SQL with the SAS community. Whether you are SAS beginner or a SAS guru, this is a must have book!

Rick Mitchell
2013 SAS Global Forum Conference Chair

Back to Top