logo
Course Catalog

Proc SQL Courses

Proc SQL is the most common data manipulation technique in SAS. In this introductory course, you will learn all the fundamental concepts of how you can manipulate the data any way you want.
  • Level: Beginners
  • 14 topics
  • 10 exercises
  • 1.5 hours
Facebook
Twitter
LinkedIn

Proc SQL Courses

Access: Subscribers only
  • Beginners
  • 14 topics
  • 1.5 hours
Start Your Training Now
  • What you will learn:
  • Data manipulation techniques using Proc SQL
  • The concepts of SQL clauses and how the data is processed
  • The LIKE operator, which allows you to filter data using keywords
  • Computing simple statistics using Proc SQL
  • Description

This is a sample course. For the full courses, please see course 1 and course 2.

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 data step, but with less code and higher efficiency.

It is often the preferred programming method of SAS professionals who work with relational databases where complex data joins are required.

Upon completion of the course, you will be able to efficiently retrieve, manipulate and analyze data using Proc SQL in SAS.

  • Software

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

  • How to set up the training:

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

  • Who this course is for:

This course is for those who are keen to learn Proc SQL - the most commonly used data manipulation techniques in SAS.

  • FAQ

Question 1: Are the two Proc SQL courses free?

No. The two Proc SQL courses are 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?

These two courses will take, on average, three hours to complete.

  • Course Content

Course Content

Expand All
Start Your Training Now

Ratings and Reviews

0.0
Avg. Rating
0 Ratings
5
0
4
0
3
0
2
0
1
0
What's your experience? We'd love to know!
No Reviews Found!
Show more reviews
What's your experience? We'd love to know!
Start Your Training Now

Copyright © 2012-2022 SASCrunch.com All rights reserved.