Proc SQL Course (Part 1)

PROC SQL greatly increases SAS’s flexibility in handling data, especially for multiple-table joining and database access, and has been widely used for SAS users, especially advanced SAS users.

This course is the first course (Part 1) for SAS Programming on Proc SQL.

It is an intermediate level course. It is designed to help you master Proc SQL programing skills and also help prepare you for the SAS certification exams.

Fee: $35

Rating: 4.9

30 Days
(money-back guarantee)

Learn Proc SQL Now

About This Course

In this course, you will learn essential SAS Proc SQL programming skills including:

Retrieving data from a single table by using the SELECT statement and its clauses(including SELECT clause, FROM clause, WHERE clause, GROUP BY clause, HAVING clause, ORDER BY clause)
Retrieving Data from Multiple Tables Using Joins including inner joins, outer joins and special joins as well as comparison of merges with joins
Using Subqueries to Select Data including single value or multiple values of subqueries, testing for the existence of a group of values, correlated subqueries, combining a Join with a subquery, and multiple Levels of subquery nesting
Combine Queries with Set Operators including UNION, EXCEPT, INTERSECT and OUTER UNION

Learn Proc SQL Now

Who is this class for?

This course is for:

Students or professionals who wants to learn SAS Proc SQL programming skills, which are highly demanded skills in SAS and statistics industry
Students or professionals who wants to become an advanced SAS programmer, and be more demanded and successful in their SAS career
Students or professionals who wants to take SAS Programming Certification Exams

Learn Proc SQL Now

Requirements

Students or professionals who plan to take this course need to have basic knowledge about SAS base programming.

You can learn SAS base programming here.

Learn Proc SQL Now

Instructor

Sharon Cheng

Online Instructor at SCStatisticalProgramming.com

Learn Proc SQL Now

Course Outline

Section 1: Proc SQL introduction
Section 2: Retrieving Data from a Single Table
Section 3: Retrieving Data from Multiple Tables using Joins
Section 4: Using Subqueries to Select Data
Section 5: Combine Queries with Set Operators

Learn Proc SQL Now

Disclosure: we are an affiliate for the course we recommended on this page. We will receive a commission if you purchase a course through our links.

Master SAS in 30 Days

Start your Free training now!