Proc SQL is an advanced SAS programming technique that allows you to retrieve, manipulate and analyze data in SAS.
It can achieve many of the same tasks as the DATA step, but with less code and higher efficiency.
It is often the preferred programming method of SAS professionals who work with relational databases that require complex data joins.
Upon completion of this course, you will be able to efficiently retrieve, manipulate and analyze data using Proc SQL 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 are keen to learn Proc SQL – the most commonly used data manipulation techniques in SAS.
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, one and a half hours to complete.
Loved the course. The lessons should keep the number titles, but also have a subject written on them as well. This would have made the lessons easier to reference later. For example: Lesson 1-1 (Proc SQL Intro) Lesson 1-2 (SELECT) Lesson 1-3 (WHERE)