SAS Programming on Data Manipulation and Preparation: Part 2
4.6 (20 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.
226 students enrolled
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.6 (20 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.
226 students enrolled
Created by Sharon Cheng
Last updated 4/2017
English
Current price: $10 Original price: $35 Discount: 71% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • 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
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:

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 training 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.

References:

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
18 Lectures
03:21:59
+
Course Overview and Supplements
2 Lectures 04:19

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

Concatenating
09:00

Appending
10:45

Interleaving
11:49

Match merging
17:57

Types of match-merging
14:04

Match Merging: Renaming Variables
13:05

Match Merging: Excluding Unmatched Observations
14:03

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

Convert Several Obs / Subject to One Obs / Subject Using a DATA Step
13:46

Convert One Obs / Subject to Several Obs / Subject Using PROC TRANSPOSE
16:04

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

Retrieve Data from Multiple Tables using Inner Join
18:07

Retrieve Data from Multiple Tables using Outer Joins
10:43
About the Instructor
Sharon Cheng
4.2 Average rating
210 Reviews
1,054 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.