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.

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