SAS Programming on Proc SQL: Part 2
4.5 (6 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.
134 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

SAS Programming on Proc SQL: Part 2

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

Are you having fun learning SAS Programming on Proc SQL: Part 1? Are you excited about completing the extremely useful SAS programming skill on Proc SQL? Here is the second part of the SAS Programming on Proc SQL courses: SAS Programming on Proc SQL: Part 2.

This course is an intermediate level course. With SAS Programming on Proc SQL: Part 1, 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 continue learning essential SAS Proc SQL programming skills on Creating and Updating Tables and Views including Creating table, Inserting Rows into Tables, Updating Data Values in a Table, Deleting Rows, Altering Columns, Deleting a Table, Using SQL Procedure Tables in SAS Software, and Creating and Using PROC SQL Views. This course also includes a section on Practical Examples Using PROC SQL, which collects common examples often encountered in workforces. The practical Proc SQL example includes Comparing Old and New Tables, Overlaying Missing Data Values, Computing Percentages within Subtotals, Counting Duplicate Rows in a Table, Expanding Hierarchical Data in a Table, Summarizing Data in Multiple Columns, Creating a Summary Report, Creating a Customized Sort Order, Updating a Table with Values from Another Table.                     

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
26 Lectures
03:02:50
+
Course Overview and Supplements
2 Lectures 03:46

course supplements: SAS codes and Data files in zip folders
01:03
+
Creating and Updating Tables and Views
15 Lectures 01:47:06

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
+
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
About the Instructor
Sharon Cheng
4.0 Average rating
265 Reviews
1,231 Students
8 Courses
online instructor; a SAS certified programmer

Before I become an online SAS programming 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. 

My website also offers: 

free SAS programming videos (also available on my YouTube channel SC statistical programming) 

free SAS programming articles

affordable online SAS programming courses at various levels