PROC SQL Masterclass on September 3rd, 2024

Kirk Paul "sasNerd" Lafler is providing an in-person training class at the Western Users of SAS Software Educational Forum and Conference on September 3rd, 2024 in Sacramento, California. Kirk will provide attendees with core concepts, features, and coding techniques on how to effectively use PROC SQL in the SAS software.

To register for the Western Users of SAS Software Educational Forum and Conference and/or Kirk's training class, click the following link: Register for Kirk's training class.

Attendees in Kirk's training class will learn how to:

• Use PROC SQL to access and retrieve data in SAS datasets (tables);
• Apply essential programming tasks including specifying SELECT statement clauses (i.e., FROM, INTO, WHERE, ON, GROUP BY, HAVING, ORDER BY);
• Understand the execution order of the SELECT clauses;
• Subset data with WHERE, ON and HAVING clauses;
• Order data and results with the ORDER BY clause;
• Group data with the GROUP BY and HAVING clauses;
• Construct logic scenarios using case expressions;
• Explore one-to-one, one-to-many, and many-to-many data relationships;
• Create inner and outer join constructs (i.e., inner and outer – left, right, and full) as well as the application of set operators to combine two or more tables together;
• Use summary (statistical) functions to aggregate data; creating new tables using three different approaches;
• Interface PROC SQL with the macro facility to create single-value (aggregate) and multi-value (list) macro variables;
• Understand the strategies and techniques related to the design and implementation of simple and composite indexes;
• Use iterative programming constructs and processes with PROC SQL and the Macro language to dynamically create data-driven programs; the application of query debugging techniques to help detect coding errors, warnings, and other issues; and the application of efficient SQL queries (scaling) for improved performance.

Kirk Paul "sasNerd" Lafler's Bio

Kirk Paul Lafler is a consultant, developer, programmer, educator, and data scientist; and teaches SAS Programming and Data Management in the Statistics Department at San Diego State University. Kirk also provides project-based consulting and programming services to client organizations; and teaches “virtual” and “live” SAS, SQL, Python, Database Management Systems (DBMS) technologies (e.g., Oracle, SQL-Server, Teradata, MySQL, MongoDB, PostgreSQL, AWS), Excel, R, and cloud-based technologies. Currently, Kirk serves as the Western Users of SAS Software (WUSS) Executive Committee (EC) Open-Source Advocate and Coordinator. Kirk is the author of several books including the popular PROC SQL: Beyond the Basics Using SAS, Third Edition (SAS Press. 2019); an Invited speaker, educator, keynote, and leader; and the recipient of 29 “Best” contributed paper, hands-on workshop (HOW), and poster awards.