Proc SQL Course 2

Proc SQL Course 2 focuses on advanced data manipulation. It explains complex table joining, which is required when manipulating real-life data. You will get to practice the techniques you learned using real-life Airbnb, Walmart and Amazon data.

Proc SQL Course 2

Access: Subscribers only

SASCrunch Proc SQL Course (Part 2) is an advanced SAS programming course focusing on the Proc SQL procedure in SAS.

It covers different types of joins and SET operators using Proc SQL. You will also learn how to update and modify SAS tables, and create integrity constraints using the SQL PROC procedure.

Upon completion of the course, you will be capable of performing complex data manipulation and analysis using one of the most powerful and commonly used procedures in SAS.

This course is based on SAS OnDemand for Academics, which is free to download.

Important! This is a coding-oriented course. You must set up the training page as instructed below:

This course is for those who want to learn advanced data manipulation skills using Proc SQL.

Question 1: Is this course free?

No. The Proc SQL course is available only to our SASCrunch Subscribers.


Question 2: What will I learn in this course?

Proc SQL is the most commonly used data manipulation technique in SAS. When dealing with large data sets, Proc SQL provides an efficient way to manipulate the data with only a few lines of code. In these two Proc SQL courses, you will learn all the common SQL techniques available in SAS.


Question 3: How long does it take to complete this mock exam?

This course will take, on average, three hours to complete.

Ratings and Reviews

Avg. Rating
3 Ratings
What's your experience? We'd love to know!
Posted 9 months ago
The examples with explaination

Everything is explained with example and data. No waste of time to type data. Just focus on topics and practice.

Preview Image
Posted 12 months ago
solid course

Thanks for this

Preview Image
David Simms
Posted 2 years ago
joins and sets

great format and delivery for learning sets and joins

Preview Image
Show more reviews
What's your experience? We'd love to know!