SAS Programming on Data Manipulation and Preparation: Part 1

Modify Variables
4.2 (33 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.
264 students enrolled
$19
$30
37% 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

About This Course

Published 10/2015 English

Course Description

This course was updated on 11/2016.

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.

·         This course was created using the SAS University Edition (The free SAS programming environment provided by SAS). 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 

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

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

Curriculum

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sharon Cheng, SAS online instructor; certified SAS 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