PROC SQL

Additional Book Details

Unlock new efficiency in your code with this comprehensive guide to PROC SQL!

PROC SQL: Beyond the Basics Using SAS, Third Edition, is a step-by-step, example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book not only covers all the basics, but it also offers extensive guidance on complex topics such as set operators and correlated subqueries. Programmers at all levels will appreciate Kirk Laflers easy-to-follow examples, clear explanations, and handy tips to extend their knowledge of PROC SQL.

This third edition explores new and powerful features in SAS 9.4, including topics such as:
IFC and IFN functions
nearest neighbor processing
the HAVING clause
indexes

It also features two completely new chapters on fuzzy matching and data-driven programming. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basics Using SAS, Third Edition, explores this powerful database language using discussion and numerous real-world examples.

Book Review

"Kirk Laflers third edition of PROC SQL: Beyond the Basics Using SAS continues to deliver essential syntax and enhanced approaches to SQL programming that are useful for all levels of SAS users. When working on a project, I find myself always going to Kirks SQL book to help debug data joins or to refresh my SQL knowledge on fuzzy matching. The third edition is a must for every SAS users desk!" MaryAnne DePesquo, Healthcare Consultant, SAS Global Forum 2019 Conference Chair

Additional resources for this book can be found by accessing the link below.