SAS Programming on Data Manipulation and Preparation: Part 1

Modify Variables
4.3 (35 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.
239 students enrolled
57% off
Take This Course
  • Lectures 28
  • Length 4.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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 10/2015 English

Course 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 already have some basic SAS programming knowledge? Do you want to enter the highly demanded SAS/data industry and become a SAS programing professional? If you answer yes, then “SAS Programming on Data Manipulation and Preparation: Part 1” is the right course for you!

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. This course can also help prepare you for SAS Base Programming Certification Exam.

This course is at the beginner to intermediate level. It is designed to help you master SAS Base Programming Essentials on Data Manipulation and Preparation. This course (Part 1) is focusing at variables’ level. The topics includes Creating labels and formats, Modifying character and numeric data values, Working with SAS dates, Generating data with DO loops, Processing variables with ARRAYS. The next course “SAS Programming on Data Manipulation and Preparation: Part 2” will be focusing at data sets modifications including data merging, combining, transforming, etc.

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 

What are the 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

What am I going to get from this course?

  • Creating labels and formats
  • Modifying character and numeric data values
  • Working with SAS dates
  • Generating data with DO loops
  • Processing variables with ARRAYS

Who is the target audience?

  • students and professionals who want to enter the highly demanded SAS/data industry and become a SAS programing professional
  • Students or professionals who want to learn SAS Base programming skills and data manipulation, which are highly demanded skills in SAS/data industry
  • This course can also help prepare you for SAS Base Programming Certification Exam.

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.


Section 1: Course Overview and Supplements
Course Overview
course supplements: SAS codes and Data files in zip folder
Section 2: Creating labels and formats
Adding Labels to Your Variables
Assigning Formats to Variables and more on SAS Built-in Formats
Creating your user-defined formats
Storing and Referencing/using your user-defined formats
Specifying Lengths for Variables
Section 3: Modifying character and numeric data values
Converting Character and Numeric Values
SCAN function: Separate a character value and obtain a specified word
SUBSTR function: Extract and replace a portion of a character value
Concatenate character values using TRIM and CATX functions
INDEX function: Search a character value for a specified string
Change the case of characters using UPCASE, LOWCASE and PROPCASE functions
TRANWRD function: Replace/remove characters within a character string
Modifying Numeric Values: INT and ROUND functions
Section 4: Working with SAS dates
MDY function: Create a SAS date value from the month, day, and year values
Extract year/quarter/month/day values(YEAR, QTR, MONTH, DAY and WEEKDAY Function
Obtain current date value and the number of time interval (TODAY, DATE, INTCK)
Calculate the difference in days and years between two dates (DATDIF, YRDIF)
Section 5: Generating data with DO loops
Constructing DO loops: part 1
Constructing DO loops: part 2
Conditionally Executing DO Loops using DO UNTIL and DO WHILE
Using Conditional Clauses with the Iterative DO Statement
Section 6: More on processing variables with ARRAYS
Creating One-Dimensional Arrays
Creating Variables in an ARRAY Statement
Assigning Initial Values to Arrays & Creating Temporary Array Elements
Two dimensional array
Section 7: Additional Lectures
Import Excel file into SAS using Proc Import

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sharon Cheng, 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.

Ready to start learning?
Take This Course