SAS Programmimg on Proc SQL: Part 1

learn SAS Proc SQL programming step by step
5.0 (5 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
66 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 29
  • Length 5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2016 English

Course Description

Course Updated on 11/16

Do you want to become a more advanced SAS programmer, and be more demanded and successful in your SAS career? If Yes, SAS Proc SQL programming should be your next programming skill to conquer.

PROC SQL is the SAS System’s implementation of Structured Query Language (SQL), which is a universal computer language for all relational database management systems. PROC SQL is the implementation of the SQL syntax in SAS. 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.

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

As the same as my other SAS programming courses, this course provides ultimate easy-to-learn environment to make your learning efficient:

·         Each lecture shows hands-on coding in SAS programming environment as well as detailed step-by-step explanations

·         The course supplements (including SAS codes and data used in lectures) are in their own formats and stored in Zip folders for easy downloading

·         This course was created using the SAS University Edition (The free SAS programming environment provided by SAS). The SAS code and data are compatible across all SAS programming environments.

REFERENCE:

SAS 9.4 SQL Procedure User's Guide, Second Edition

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

What are the requirements?

  • Students or professionals who plan to take this course need to have basic knowledge about SAS programming, such as already taken my course 'SAS programming for beginners' or equivalent

What am I going to get from this course?

  • 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

What is the target audience?

  • 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 SAS Programming Certification Exams

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Overview and Supplements
Course Introduction
Preview
03:20
Course Supplements: SAS codes and Data files in zip folders
01:04
Section 2: Section 1: Proc SQL introduction
Proc SQL introduction
08:27
Section 3: Section 2: Retrieving Data from a Single Table
SELECT Statement: Overview
16:17
SELECT Clause: Eliminate Duplicate Rows Using the DISTINCT Keyword
Preview
11:09
SELECT Clause: Create Columns
12:32
SELECT Clause: Assign Values Conditionally by Using a CASE Expression
12:49
SELECT Clause: Replace Missing Values with COALESCE Function and Case Expression
11:25
ORDER BY Clause: Sort Data
14:13
WHERE Clause: Retrieving Rows That Satisfy a Condition
18:01
Summarizing Data using aggregate functions (or summary functions)
14:35
GROUP BY Clause: Group Data
17:11
HAVING Clause: Filter Grouped Data
07:57
Section 4: Section 3: Retrieving Data from Multiple Tables using Joins
Inner Join Data: Use Where Clause, Use Inner Join keyword, Comparison Operators
Preview
13:44
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:46
Outer Join Data: Left, Right and Full Outer Joins
12:38
Specialty Joins: cross joins, union joins, and natural joins
14:23
Comparison of DATA Step Match-Merges with PROC SQL Joins: Part 1
15:11
Comparison of DATA Step Match-Merges with PROC SQL Joins: Part 2
07:59
Section 5: Section 4: Using Subqueries to Select Data
Single-Value and Multiple-Value Subqueries
12:30
Testing for the Existence of a Group of Values
05:58
Correlated Subqueries and Combining a Join with a Subquery
Preview
09:21
Multiple Levels of Subquery Nesting
08:35
Section 6: Section 5: Combine Queries with Set Operators
UNION: Produce all unique rows from both queries
Preview
12:35
EXCEPT: Produce all unique rows from both queries
09:15
INTERSECT: Produce rows that are common to both query results
04:59
OUTER UNION: Concatenate the query results
04:35
Produce Rows from the First or Second Query
06:40

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sharon Cheng, SAS online instructor; certified SAS programmer

Before I become an online SAS instructor, I have worked as a statistician/SAS programmer for 7 years. I am a SAS certified professional and highly proficient in SAS programming, and I enjoy teaching as well. Now I would like to use my SAS programming skills to help people learning SAS in an easy and affordable way. I have a website offering free SAS tutorial videos (also available on my YouTube channel TreehouseofSASprogramming) and affordable online SAS tutorial courses at various levels.

Ready to start learning?
Take This Course