Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add SAS Programming on Data Manipulation and Preparation: Part 2 to your Wishlist.

Add to Wishlist

SAS Programming on Data Manipulation and Preparation: Part 2

Modify Data Sets
4.3 (14 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.
156 students enrolled
Created by Sharon Cheng
Last updated 2/2017
$10 $35 71% off
3 days left at this price!
30-Day Money-Back Guarantee
  • 3.5 hours on-demand video
  • 18 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Combining SAS Data sets in multiple ways
Reconstructing SAS Data sets using both data step and Proc Transpose procedure
Having basic understanding about Proc SQL and being able to retrieve data from single table and perform basic joins
View Curriculum
  • Students 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

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:

Almost all the data needs to be
manipulated/prepared before data analysis. Every SAS programmer is required
to master SAS data manipulation and preparation programming skills,
which are critical and highly demanded in the SAS/data industries. Now it is
the time to complete the SAS
programming on data
manipulation and preparation
with this class. The two courses on Data Manipulation and
Preparation can also help prepare you for the
SAS Base Programming Certification Exam.

SAS programming on Data Manipulation and preparation Part II is the second course for SAS programming on Data Manipulation and preparation. In ‘SAS programming on Data Manipulation and preparation Part I’, we covered various topics on how to manipulate and prepare data at variable level. Now it is the time to talk about how to manipulate and prepare data at data set level. This course is at the beginner to intermediate level. It covers SAS datasets merging, combining, transforming, reshaping, as well as a section focusing on introduction to Proc SQL.

As the same as my other SAS programming courses, this course utilizes

·         Hands-on coding in SAS programming environment as well as detailed step-by-step explanations to make your learning easy and fast.

·         The course supplements (including SAS codes and data used in lectures) are easy downloadable for your own practice.

·         The SAS code and data are compatible across all SAS programming environments.


SAS certification prep guide: base programming by SAS Institute

The little SAS book: a primer / Lora D. Delwiche and Susan J. Slaughter

Learning SAS by example: a programmer's guide / Ron Cody

SAS 9.4 SQL procedure user's guide by SAS Institute

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

Who is the target audience?
  • Students or professionals who wants to take SAS Certification on Base Programming
  • Students or professionals who wants to learn data manipulation which is highly demanded skills in SAS and statistics industry
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 18 Lectures Collapse All 18 Lectures 03:21:31
Course Overview and Supplements
2 Lectures 03:51

course supplements: SAS codes and Data files in zip folder
Combining SAS data sets
9 Lectures 01:47:57




Match merging

Types of match-merging

Match Merging: Renaming Variables

Match Merging: Excluding Unmatched Observations

Match Merging: Selecting Variables
Reconstructing SAS Data sets
4 Lectures 50:26

Convert Several Obs / Subject to One Obs / Subject Using a DATA Step

Convert One Obs / Subject to Several Obs / Subject Using PROC TRANSPOSE

Convert Several Obs / Subject to One Obs / Subject Using PROC TRANSPOSE
Introduction to Proc SQL (structured query language)
3 Lectures 39:17

Retrieve Data from Multiple Tables using Inner Join

Retrieve Data from Multiple Tables using Outer Joins
About the Instructor
4.3 Average rating
119 Reviews
662 Students
5 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.

Report Abuse