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.
*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.
Featured Authors
-
Terisa Roberts is a director and Global Solution lead for Risk Modeling and Decisioning at SAS. She has extensive experience in quantitative risk management, regulatory compliance, and model governance and validation. She has worked in financial services, telecommunications, government, energy, and retail sectors.
-
Ron Klimberg, PhD, is a professor at the Haub School of Business at Saint Joseph's University in Philadelphia, PA.
-
Robert N. Rodriguez retired from SAS in 2018 after serving as a senior director in research and development. Bob received a PhD in statistics from the University of North Carolina at Chapel Hill and was a research statistician at General Motors Research Laboratories before joining SAS.
-
Todd Case has been working in the pharmaceutical industry as a statistical programmer for over 20 years. He completed his MS in Epidemiology from Columbia University and has worked at Forest Laboratories (now Allergan), Genentech, Bristol-Myers Squibb, and Biogen. He currently works at Vertex Pharmaceuticals.