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.
PROC SQL: Beyond the Basics Using SAS®, Second Edition
*Replaced by PROC SQL: Beyond the Basics Using SAS®, Third Edition.
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.
- Kim Chantala is a Programmer Analyst in the Research Computing Division at RTI International with over 25 years of experience in managing and analyzing research data. Before joining RTI International, she was a data analyst at the University of North Carolina at Chapel Hill.
- Ron Cody, EdD, a retired professor from the Robert Wood Johnson Medical School now works as a private consultant and a national instructor for SAS Institute.
- Michele M. Burlew designed and programmed SAS applications for data management, data analysis, report writing, and graphics for academic and corporate clients for over 40 years. She has expertise in many SAS products and operating systems.