SAS Programming on Data Manipulation and Preparation: Part 1
4.1 (47 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.
346 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

SAS Programming on Data Manipulation and Preparation: Part 1

Modify Variables
4.1 (47 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.
346 students enrolled
Created by Sharon Cheng
Last updated 4/2017
English
Current price: $10 Original price: $35 Discount: 71% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Creating labels and formats
  • Modifying character and numeric data values
  • Working with SAS dates
  • Generating data with DO loops
  • Processing variables with ARRAYS
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:

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.

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 

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
28 Lectures
04:31:22
+
Course Overview and Supplements
2 Lectures 03:49

course supplements: SAS codes and Data files in zip folder
01:03
+
Creating labels and formats
5 Lectures 57:23
Adding Labels to Your Variables
07:39

Assigning Formats to Variables and more on SAS Built-in Formats
13:13


Storing and Referencing/using your user-defined formats
15:52

Specifying Lengths for Variables
07:47
+
Modifying character and numeric data values
8 Lectures 01:12:53

SCAN function: Separate a character value and obtain a specified word
07:11

SUBSTR function: Extract and replace a portion of a character value
10:00

Concatenate character values using TRIM and CATX functions
09:57

INDEX function: Search a character value for a specified string
09:25

Change the case of characters using UPCASE, LOWCASE and PROPCASE functions
05:53

TRANWRD function: Replace/remove characters within a character string
06:22

Modifying Numeric Values: INT and ROUND functions
06:27
+
Working with SAS dates
4 Lectures 42:29

Extract year/quarter/month/day values(YEAR, QTR, MONTH, DAY and WEEKDAY Function
11:52

Obtain current date value and the number of time interval (TODAY, DATE, INTCK)
07:53

Calculate the difference in days and years between two dates (DATDIF, YRDIF)
11:28
+
Generating data with DO loops
4 Lectures 32:51
Constructing DO loops: part 1
09:54

Constructing DO loops: part 2
09:33

Conditionally Executing DO Loops using DO UNTIL and DO WHILE
06:49

Using Conditional Clauses with the Iterative DO Statement
06:35
+
More on processing variables with ARRAYS
4 Lectures 44:19
Creating One-Dimensional Arrays
14:45


Assigning Initial Values to Arrays & Creating Temporary Array Elements
13:22

Two dimensional array
08:40
+
Additional Lectures
1 Lecture 17:38
Import Excel file into SAS using Proc Import
17:38
About the Instructor
Sharon Cheng
4.2 Average rating
211 Reviews
1,056 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.