Kirk Paul Lafler

Kirk Paul Lafler
Consultant/Founder, Software Intelligence Corporation

Kirk Paul Lafler is an entrepreneur, founder, and consultant at Software Intelligence Corporation and has worked with SAS software since 1979. As a SAS consultant, application developer, programmer, data analyst, educator, and author at Software Intelligence Corporation, Kirk currently serves as a lecturer and adjunct professor at San Diego State University, an advisor and SAS programming adjunct professor at the University of California San Diego Extension, and an educator who teaches SAS courses, workshops, seminars, and webinars to thousands of users around the world. Kirk has also authored or co-authored several books including PROC SQL: Beyond the Basics Using SAS, Third Edition (SAS Press 2019) and Google® Search Complete! (Odyssey Press 2014); hundreds of papers and articles on a variety of SAS topics; selected as an invited speaker, educator, keynote and section leader at SAS user group conferences and meetings worldwide; and is the recipient of 25 "Best" contributed paper, hands-on workshop (HOW), and poster awards.

 By This Author


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

By Kirk Paul Lafler

Kirk Lafler's PROC SQL: Beyond the Basics Using SAS, Third Edition, offers 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 examines a broad range of topics and provides greater detail about this powerful database language.

The third edition explores the latest features in SAS 9.4, and includes two brand-new chapters on fuzzy matching and data-driven programming.

*Our books are also available in print and e-book formats
from your local bookstore or favorite online bookseller.

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

By Kirk Paul Lafler

A step-by-step example-driven guide that helps readers master the language of PROC SQL. The second edition explores new and powerful features in SAS 9.3. 

PROC SQL: Beyond the Basics Using SAS

PROC SQL: Beyond the Basics Using SAS®

By Kirk Paul Lafler

Addresses database design; an introduction to SQL, dictionary tables, and tables; coding PROC SQL logic as well as complex queries; working with views; troubleshooting and debugging SQL code; and more. Covers both American National Standards Institute (ANSI) guidelines and non-ANSI features.