SAS Programmimg on Proc SQL: Part 1
4.0 (23 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.
173 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAS Programmimg on Proc SQL: Part 1 to your Wishlist.

Add to Wishlist

SAS Programmimg on Proc SQL: Part 1

learn SAS Proc SQL programming step by step
4.0 (23 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.
173 students enrolled
Created by Sharon Cheng
Last updated 2/2017
English
Current price: $10 Original price: $35 Discount: 71% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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
Description

This course was updated on 01/2017.

Please Note:

The course's provider is Sharon @ SC statistical programming (formerly treehouse of SAS programming, which is replaced by SC statistical programming). 

I have the SAS software licence, which allows me to create and sell video-based SAS programming online courses.

Course Description:

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

·         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

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
29 Lectures
05:06:37
+
Course Overview and Supplements
2 Lectures 04:08

Course Supplements: SAS codes and Data files in zip folders
01:03
+
Section 1: Proc SQL introduction
1 Lecture 08:23
Proc SQL introduction
08:23
+
Section 2: Retrieving Data from a Single Table
10 Lectures 02:14:34
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
+
Section 3: Retrieving Data from Multiple Tables using Joins
7 Lectures 01:26:37

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
+
Section 4: Using Subqueries to Select Data
4 Lectures 35:43
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
+
Section 5: Combine Queries with Set Operators
5 Lectures 37:12

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
About the Instructor
Sharon Cheng
4.2 Average rating
211 Reviews
1,057 Students
7 Courses
online instructor; a SAS certified 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.