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.
Everything is explained with example and data. No waste of time to type data. Just focus on topics and practice.