Proc SQL: Beyond the Basics Using SAS, Third Edition / Edition 3

by Kirk Paul Lafler

Overview

PROC SQL: Beyond the Basics Using SAS^(R), 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 Lafler's 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(R) 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^(R), Third Edition, explores this powerful database language using discussion and numerous real-world examples.

Product Details

ISBN-13:	9781635266849
Publisher:	SAS Institute
Publication date:	03/20/2019
Edition description:	3rd ed.
Pages:	420
Product dimensions:	7.50(w) x 9.25(h) x 0.86(d)

About the Author

Kirk Paul Lafler is founder and entrepreneur at Software Intelligence Corporation. He has worked with SAS software since 1979 as a consultant, application designer and developer, programmer, SAS solutions provider, data analyst, educator, and author. As a SAS Certified professional, mentor, and educator at Software Intelligence Corporation and as an advisor and SAS programming adjunct professor at the University of California San Diego Extension, Lafler has taught SAS courses, seminars, workshops, and webinars to thousands of users around the world. He received his BS and MS degrees from the University of Miami. Lafler is a frequent speaker at international, regional, special-interest, local, and in-house SAS users group conferences and meetings. He has also authored or co-authored several books, including Google(R) Search Complete and PROC SQL: Beyond the Basics Using SAS(R); hundreds of papers and articles on a variety of SAS topics; and a popular SAS tips column, called "Kirk's Korner." He has also served as an invited speaker, instructor, keynote speaker, and section leader at SAS users group conferences and meetings around the world and is the recipient of numerous "Best" contributed paper, hands-on workshop (HOW), and poster awards.

Editorial Reviews

"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." -- Sunil Gupta, Director of Statistical Programming "Cytel"

From the Publisher