PROC SQL Programming: Beyond the Basics Using SAS®

Kirk Paul Lafler is a globally recognized data scientist, consultant, educator, programmer, author, and speaker with more than 40 years of experience delivering practical, real-world analytics training. His expertise spans SAS, SQL, Python, R, databases, big data, AI, machine learning, and cloud technologies. Known for transforming complexity into clarity, Kirk helps learners build confidence and proficiency through hands-on, applied instruction.

Kirk Paul Lafler - Python, AI, SQL, & SAS Trainer

Learn PROC SQL and beyond the basics programming techniques using SAS® from a leading expert.

Iowa Department of Education

<h3><strong>Course Description:</strong></h3><p>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.</p><p></p><h3><strong>I﻿nstructor Bio:</strong></h3><p>Kirk Paul Lafler is a SAS, SQL, RDBMS, Excel, and Python educator, developer, programmer, consultant, and data analyst; and works as an adjunct professor at San Diego State University; an advisor and adjunct professor at the University of California San Diego Extension; and an educator teaching SAS, SQL, Python, Excel, and cloud-based technology courses, workshops, and webinars to users virtually around the world. Kirk has nearly 50 years of programming experience and specializes in SAS software, SQL, RDBMS technologies (Oracle, SQL-Server, Teradata, DB2), Python, and other languages and productivity tools. As an author, Kirk’s most recent books include Exploratory Data Analysis (EDA) By Example (PB&amp;J Press. Summer 2023), Python ETL By Example (PB&amp;J Press, Spring 2024), PROC SQL: Beyond the Basics Using SAS, Third Edition (SAS Press. 2019), and other books along with numerous papers and articles on a variety of SAS, SQL, and Python topics. Kirk is actively involved with international, regional, and local SAS, SQL, and Python user groups and conferences as an Invited speaker, educator, keynote, and section leader; and is the recipient of 27 “Best” contributed paper, hands-on workshop (HOW), and poster awards.</p><p></p><h3><strong>L﻿inkedIn Profile:</strong></h3><p>https://www.linkedin.com/in/kirkpaullafler/</p><p></p><h3><strong>Course Date:</strong>
</h3><p>Wednesday, May 24, 2023</p><h3><strong>Training Location:</strong></h3><p>Iowa Department of Education, 400 E. 14th St., Des Moines, IA 50319, USA.</p><h3><strong>Intended Audience: </strong></h3><p>Programmers, Data Analysts, Data Scientists, Statisticians, Database Users, and Others wanting to Learn PROC SQL.</p><h3><strong>Prerequisites: </strong></h3><p>No previous PROC SQL programming experience required.</p><h3><strong>Delivery Method: </strong></h3><p>Instructor-led workshop with PROC SQL code examples.</p><h3><strong>Length: </strong></h3><p>3.5 Hours (8:30 AM – 12:00 Noon).</p><h3><strong>Course Material: </strong></h3><p>Course Notes will be provided to each attendee as a PDF document. PROC SQL code is provided to each attendee.</p><h3><strong>Q﻿uestions:</strong></h3><p>Contact Kirk Paul Lafler, KirkLafler@cs.com</p><p></p><p>S﻿AS is the registered trademark of SAS Institute Inc., Cary, NC, USA.</p>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

PROC SQL Programming: Beyond the Basics Using SAS®

More events from Kirk Paul Lafler - Python, AI, SQL, & SAS Trainer

Discover more events from Kirk Paul Lafler - Python, AI, SQL, & SAS Trainer, from Business to other experiences you might love.

PROC SQL Programming: Beyond the Basics Using SAS®

More events from Kirk Paul Lafler - Python, AI, SQL, & SAS Trainer

Discover more events from Kirk Paul Lafler - Python, AI, SQL, & SAS Trainer, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.