About this Course

301,526 recent views

Learner Career Outcomes

21%

started a new career after completing these courses

26%

got a tangible career benefit from this course

10%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 1 of 3 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 24 hours to complete
English

Instructor

Learner Career Outcomes

21%

started a new career after completing these courses

26%

got a tangible career benefit from this course

10%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 1 of 3 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 24 hours to complete
English

Offered by

Placeholder

SAS

Syllabus - What you will learn from this course

Content RatingThumbs Up94%(6,368 ratings)Info
Week
1

Week 1

1 hour to complete

Course Overview and Data Setup

1 hour to complete
3 videos (Total 10 min), 5 readings
3 videos
Demo: Programming in SAS7m
Practicing in This Course35s
5 readings
Learner Prerequisites10m
Choosing and Setting Up SAS Software for this Course10m
Need Help Setting Up Software?10m
Follow These Instructions to Set Up Practice Files for This Course (REQUIRED)30m
Using Forums and Getting Help10m
2 hours to complete

Essentials

2 hours to complete
7 videos (Total 16 min), 2 readings, 3 quizzes
7 videos
SAS Programming Interfaces56s
Demo: Programming with SAS Studio4m
SAS Program Structure2m
SAS Program Syntax55s
Demo: Understanding SAS Program Syntax2m
Demo: Finding and Resolving Syntax Errors4m
2 readings
Practice Using SAS Studio20m
Syntax Review10m
3 practice exercises
Activity 1.0110m
Activity 1.0210m
Essentials30m
Week
2

Week 2

3 hours to complete

Accessing Data

3 hours to complete
14 videos (Total 27 min), 1 reading, 9 quizzes
14 videos
Types of Data1m
What is a SAS Table?1m
Required Column Attributes for SAS Tables2m
Listing Table and Column Attributes1m
Accessing Data in a Program1m
Using a Library to Read SAS Data3m
Automatic SAS Libraries1m
Demo: Exploring Automatic SAS Libraries3m
Using a Library to Read Other File Types2m
Demo: Using a Library to Read Excel Files3m
Importing Unstructured Data2m
Demo: Importing a Comma-Delimited (CSV) File2m
Importing an Excel File1m
1 reading
Syntax Review10m
9 practice exercises
Question 2.015m
Activity 2.0210m
Activity 2.0310m
Activity 2.04: Create a Library for This Course (Required)10m
Activity 2.0510m
Activity 2.0610m
Level 1 Practice: Importing Excel Data from a Single Worksheet20m
Level 2 Practice: Importing Data from a CSV File20m
Accessing Data30m
Week
3

Week 3

5 hours to complete

Exploring and Validating Data

5 hours to complete
16 videos (Total 41 min), 1 reading, 14 quizzes
16 videos
Exploring Data with Procedures1m
Demo: Exploring Data with SAS Procedures6m
Filtering Rows with the WHERE Statement1m
Combining Expressions in a WHERE Statement58s
Demo: Filtering Rows with Basic Operators5m
Using Special WHERE Operators1m
Creating and Using Macro Variables2m
Demo: Filtering Rows Using Macro Variables3m
Formatting Data Values in Results1m
Common Formats for Numeric Values1m
Common Formats for Date Values26s
Demo: Formatting Data Values in Results3m
Sorting Data1m
Identifying and Removing Duplicates1m
Demo: Identifying and Removing Duplicate Values5m
1 reading
Syntax Review10m
14 practice exercises
Activity 3.0110m
Level 1 Practice: Exploring Data with Procedures20m
Level 2 Practice: Using Procedures to Validate Data20m
Activity 3.0210m
Activity 3.0310m
Activity 3.0410m
Level 1 Practice: Filtering Rows in a Listing Report Using Character Data20m
Level 2 Practice: Using Macro Variables to Subset Data in Procedures20m
Activity 3.0510m
Activity 3.0610m
Activity 3.0710m
Level 1 Practice: Sorting Data and Creating an Output Table20m
Level 2 Practice: Sorting Data to Remove Duplicate Rows20m
Exploring and Validating Data30m
Week
4

Week 4

5 hours to complete

Preparing Data

5 hours to complete
13 videos (Total 28 min), 4 readings, 16 quizzes
13 videos
Using the DATA Step to Create a SAS Data Set1m
DATA Step Processing1m
Demo: Working with the DATA Step3m
Demo: Using Expressions to Create New Columns3m
Using Numeric Functions to Create Columns57s
Demo: Using Character Functions2m
Demo: Using Date Functions3m
Demo: Conditional Processing with IF-THEN3m
Conditional Processing with IF-THEN/ELSE1m
Creating Character Columns with the LENGTH Statement1m
Processing Multiple Statements with IF-THEN/DO1m
Demo: Processing Multiple Statements with IF-THEN/DO2m
4 readings
Common Summary Functions for Creating Columns5m
Common Character Functions for Creating Columns2m
Common Date Functions for Creating Columns2m
Syntax Review10m
16 practice exercises
Question 4.015m
Question 4.022m
Activity 4.0310m
Level 1 Practice: Creating a SAS Table20m
Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table20m
Activity 4.0410m
Activity 4.0510m
Activity 4.0610m
Level 1 Practice: Creating New Columns20m
Level 2 Practice: Creating New Columns with Character and Date Functions20m
Activity 4.0710m
Activity 4.0810m
Activity 4.0910m
Level 1 Practice: Processing Statements with IF-THEN/ELSE20m
Level 2 Practice: Processing Statements Conditionally with DO Groups20m
Preparing Data30m

Reviews

TOP REVIEWS FROM GETTING STARTED WITH SAS PROGRAMMING

View all reviews

About the SAS Programmer Professional Certificate

SAS Programmer

Frequently Asked Questions

More questions? Visit the Learner Help Center.