logo

Proc SQL Course 1

Proc SQL is the most common data manipulation technique in SAS. In this introductory course, you will learn all the fundamental concepts of how to manipulate data any way you want.
Facebook
Twitter
LinkedIn

Proc SQL Course 1

Access: Subscribers only

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.

Ratings and Reviews

4.0
Avg. Rating
2 Ratings
5
0
4
2
3
0
2
0
1
0
What's your experience? We'd love to know!
mckenny10
Posted 3 months ago
SQL Made Easy

This tutorial provides a good mixture of SAShelp datasets and unique options which is helpful. It also covers the basics of SQL in quite plain terms which is also helpful. The only thing missing is more attention to subqueries as this is where most analysts get stuck.

×
Preview Image
Brian Fullilove
Posted 2 years ago
Great Course! hard to search prior lessons.

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)

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