Canceled - Instructor-led Course: PROC SQL Programming: Beyond the Basics Using SAS?

Dear SAS? Users,

Everyone in the SANDS organization wishes to extend our thanks to you for registering for the SANDS-sponsored PROC SQL Programming: Beyond the Basics Using SAS? course scheduled on March 19th, 2020. However, your safety and well-being are paramount to us. After careful consideration of the evolving concerns around COVID-19, we’ve made the difficult decision to cancel this in-person training event by Kirk Paul Lafler at Pfizer in La Jolla, California.

We all recognize that this could present some inconvenience to you. So, we are working to offer this course, and other, virtually. We are also in contact with EventBrite to refund your payment for the training event. Please be patient while this happens. Once we have scheduled future training events we will notify you via email and on LinkedIn.

We look forward to hosting future training events whether in-person and/or virtually. We hope that you will keep an eye out for additional information about upcoming training events that we offer.

Stay healthy, everyone!

SANDS

San Diego SAS Users Group

https://www.sandsug.org/

Course Details:

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; 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 (array) macro variables; and apply a number of query debugging techniques to help detect coding errors, warnings and other messages.

Intended Audience: All SAS users

Prerequisites: Minimum 1-year Base-SAS programming experience

Delivery Method: Instructor-led with code examples (No computers will be available)

Date: Thursday, March 19th, 2020

Time: 1:00 pm - 4:00 pm

Location: Pfizer La Jolla Campus, 10770 Science Center Drive, Building CB2, Room 1110, San Diego, California 92121

Course Material: Course Notes will be provided

Cost: $129.00 when RSVP is received on or before Friday, March 6th, 2020.

          $149.00 when RSVP received after March 6th, 2020.

Bio for Kirk Paul Lafler, Instructor

SAS? Consultant, Application Developer, Programmer, Data Analyst, Educator & Author

Kirk Paul Lafler is an entrepreneur, founder and consultant at Software Intelligence Corporation, and has used SAS software since 1979. Kirk currently serves as a consultant, application developer, programmer, SAS solutions provider, data analyst, educator and author; a lecturer and adjunct professor at San Diego State University; an advisor and adjunct professor at the University of California San Diego Extension; and an educator of dozens of SAS, SQL, R and Python courses, seminars, workshops, and webinars to thousands of 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.

Registration Details

The San Diego SAS Users Group (SANDS) is excited to offer and to have Kirk Paul Lafler teach this 3-hour instructor-led PROC SQL Programming: Beyond the Basics Using SAS? course on Thursday, March 19th, 2020 at Pfizer’s La Jolla campus. To register, RSVP using Eventbrite.com to secure your seat in this course. Kirk will teach this popular course emphasizing useful programming techniques for SAS learners to acquire and enhance their skills using the PROC SQL and the SAS software. Due to limited seating, take advantage of early-bird pricing at $129 by RSVPing no later than Friday, March 6th, 2020 to hold your seat in this popular course. The cost will increase to $149 when RSVPing after March 6th, 2020. Register using the Eventbrite app by clicking this link.

For directions to the Pfizer La Jolla Campus, see the map below. The SANDS Executive Committee and Kirk Paul Lafler are excited to offer this instructor-led course and look forward to seeing you on Thursday, March 19th, 2020.

SAS is the registered trademark of SAS Institute Inc., Cary, NC, USA.