The Ultimate SAS SQL course: SAS Programming on Proc SQL
4.4 (137 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
863 students enrolled

The Ultimate SAS SQL course: SAS Programming on Proc SQL

learn SAS SQL programming step by step and master SAS Proc SQL easily
Bestseller
4.4 (137 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
863 students enrolled
Created by sharon cheng
Last updated 8/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9 hours on-demand video
  • 10 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Master SAS SQL (Proc SQL) programming
  • Proc SQL Overview
  • SELECT Statement: Retrieving Data from a Single Table
  • JOINS: Retrieving Data from Multiple Tables using Joins
  • SUBQUERIES: Using Subqueries to Select Data
  • Combine Queries with Set Operators (UNION, EXCEPT, INTERSECT, OUTER UNION etc.)
  • Creating and Updating Tables and Views
  • Practical Examples Using PROC SQL (9 practical examples)
Course content
Expand all 67 lectures 08:58:15
+ Course Overview, Course Supplements, SAS University (SAS Studio) Installation
6 lectures 52:36
the complete and step-by-step guide to Install SAS studio
14:58
Virtual box 6.0: download and set up SAS University Edition & its shared folder
11:45

Video shows how to download zip files, and copy & paste the files into right folder.

Video is using another course's materials as an example, so the actual downloadable file names may be different.

Downloadable course materials: SAS programs and Data used in the course + PPTs
06:28
File path/directory in SAS studio
04:25
How to use SAS onDemand academics if you can NOT install SAS University Edition
11:53
+ SELECT Statement: Retrieving Data from a Single Table
12 lectures 02:15:28
SELECT Statement: Overview
16:12
SELECT Clause: Create Columns
12:27
SELECT Clause: Assign Values Conditionally by Using a CASE Expression
12:36
SELECT Clause: Replace Missing Values with COALESCE Function and Case Expression
11:10
ORDER BY Clause: Sort Data
14:00
WHERE Clause: Retrieving Rows That Satisfy a Condition
17:48
Summarizing Data using aggregate functions (or summary functions)
14:23
GROUP BY Clause: Group Data
17:04
HAVING Clause: Filter Grouped Data
07:49
Retrieving Data from a Single Table
9 questions
Coding Exercise
00:15
Coding Exercise: Solution
00:38
+ JOINS: Retrieving Data from Multiple Tables using Joins
9 lectures 01:27:35
Inner Join Data: Effect of Missing Values on Join, Use Multiple Matching Columns
14:49
Inner Join Data: Inner Join More Than Two Tables, Self-Joins
08:41
Outer Join Data: Left, Right and Full Outer Joins
12:27
Specialty Joins: cross joins, union joins, and natural joins
14:13
Comparison of DATA Step Match-Merges with PROC SQL Joins: Part 1
14:55
Comparison of DATA Step Match-Merges with PROC SQL Joins: Part 2
07:54
Retrieving Data from Multiple Tables using Joins
4 questions
Coding Exercise
00:12
Coding Exercise: Solution
00:45
+ SUBQUERIES: Using Subqueries to Select Data
6 lectures 36:30
Single-Value and Multiple-Value Subqueries
12:20
Testing for the Existence of a Group of Values
05:48
Multiple Levels of Subquery Nesting
08:24
Using Subqueries to Select Data
3 questions
Coding Exercise
00:11
Coding Exercise: Solution
00:36
+ Combine Queries with Set Operators (UNION, EXCEPT, INTERSECT, OUTER UNION etc.)
7 lectures 37:56
EXCEPT: Produce all unique rows from both queries
09:07
INTERSECT: Produce rows that are common to both query results
04:51
OUTER UNION: Concatenate the query results
04:19
Produce Rows from the First or Second Query
06:29
Combine Queries with Set Operators
3 questions
Coding Exercise
00:06
Coding Exercise: Solution
00:38
+ Creating and Updating Tables and Views
17 lectures 01:47:48
Create Tables from a Query Result using CREATE TABLE with AS Keyword
06:36
Create Tables like an Existing Table with LIKE clause & Copy an Existing Table
06:45
Insert Rows into Tables using Insert Statement with the SET Clause
09:04
Insert Rows into Tables using Insert Statement with the VALUE Clause
08:09
Insert Rows into Tables using Insert Statement with a Query
09:16
Update All Rows with the Same Expression using Update Statement
06:32
Delete Rows with the DELETE statement
04:59
Alter Columns with the ALTER TABLE statement: Add a Column
08:49
Alter Columns with the ALTER TABLE statement: Modify or Delete a Column
03:51
Use SQL Procedure Tables & Delete Tables
04:34
Proc SQL Views: Create, Describe, and Delete PROC SQL Views
07:47
Proc SQL Views: Use Proc SQL Views
05:04
Proc SQL Views: Specify/Use In-Line Views
08:23
Quiz 5
16 questions
Coding Exercise
00:14
Coding Exercise: Solution
00:27
+ Practical Examples Using PROC SQL
9 lectures 01:11:58
Comparing Old and New Tables
07:05
Overlaying Missing Data Values
09:00
Counting Exact Duplicate Rows in a Table
04:56
Expanding Hierarchical Data in a Table
06:28
Summarizing Data in Multiple Columns
05:45
Creating a Summary Report
10:13
Creating a Customized Sort Order
08:15
Updating a Table with Values from Another Table
09:06
Requirements
  • basic knowledge about SAS programming
Description

Course Highlights:

  • This course contains all the essential SAS SQL programming techniques to help you master SAS Proc SQL programming skills and also help prepare you for the SAS certification exams.

  • A combined course (9 hours video-based lectures, 67 lectures), which contains the following two individual courses to provide the maxim benefit for my students:

SAS Programming on Proc SQL part 1

SAS Programming on Proc SQL part 2

(The contents of this course is also included in SAS Programming Advanced Certification Prep Course: 3 in 1, which is a combined course with 4 individual courses. If you purchased SAS Programming Advanced Certification Prep Course: 3 in 1, you don't need to purchase this course)

  • step by step/ code by code explanations for easy and efficient learning

  • downloadable data, SAS programs and Power Point slides used in the course (the course materials are ONLY for practice, they are protected by copyright)

  • Quizzes, coding exercises and practical examples. After all, practice makes perfection!

Notes on Course ratings and reviews:

Please be considerate and sincere when you provide ratings. This will encourage me providing more contents to the course and better service to you! Please provide fair ratings to this course with the consideration of the comparison among other available SAS advanced courses.

Course Description:

This course is a combined course, which contains the following two individual courses to provide the maxim benefit for my students:

SAS Programming on Proc SQL part 1

SAS Programming on Proc SQL part 2

This is an intermediate level course. It contains all the SAS SQL programming essential techniques to help you master SAS Proc SQL programming skills and also help prepare you for the SAS certification exams.

This course include 7 sections (Please see course curriculum for more detailed information on lectures included in each section)

  • Course Overview, Course Supplements, SAS University (SAS Studio) Installation

  • Proc SQL Overview / Introduction

  • SELECT Statement: Retrieving Data from a Single Table

  • JOINS: Retrieving Data from Multiple Tables using Joins

  • SUBQUERIES: Using Subqueries to Select Data

  • Combine Queries with Set Operators (UNION, EXCEPT, INTERSECT, OUTER UNION etc.)

  • Creating and Updating Tables and Views

  • Practical Examples Using PROC SQL (9 practical examples)   

REFERENCE:   

SAS 9.4 SQL Procedure User's Guide, Second Edition   

SAS certification prep guide: advanced programming for SAS 9 by SAS Institute

Note: A SAS software licence allows SC statistical programming to create and sell video-based SAS programming online courses.

Who 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 and 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 Advanced SAS Programming Certification Exams