PROC SQL Programming: Beyond the Basics Using SAS®
Presented by: Kirk Paul Lafler is an entrepreneur, consultant, programmer and educator, and has been a SAS user since 1979. Kirk is a lecturer and adjunct professor at San Diego State University; an advisor and adjunct professor at the University of California San Diego Extension; and teaches dozens of SAS, SQL, Excel, R and Python courses, seminars, workshops, and webinars to users around the world. As the author of several books including PROC SQL: Beyond the Basics Using SAS, Third Edition (SAS Press. 2019) along with hundreds of papers and articles on a variety of SAS topics; Kirk has been selected as an Invited speaker, educator, keynote and section leader at SAS conferences and meetings worldwide; and is the recipient of 25 “Best” contributed paper, hands-on workshop (HOW), and poster awards.
PROC SQL Programming: Beyond the Basics Using SAS® provides SAS® and SQL users with core concepts, features and techniques on how to effectively use PROC SQL. Attendees learn how to use PROC SQL to access data in SAS datasets (tables); review essential programming tasks including retrieving, execution order of the SELECT clauses, subsetting, ordering, and grouping data; construct logic scenarios with case expressions; explore one-to-one, one-to-many, and many-to-many data relationships; understand the similarities and differences between DATA step merges and joins; create inner and outer join constructs as well as apply set operators to combine two or more tables together; use summary (statistical) functions to aggregate data; create new tables using three different approaches; interface PROC SQL and the macro facility to create single-value and multi-value (list) macro variables; apply a number of query debugging techniques to help detect coding errors, warnings and other messages; and scale SQL queries for improved performance.