About this Course
4.7
7 ratings
2 reviews
100% online

100% online

Start instantly and learn at your own schedule.
Flexible deadlines

Flexible deadlines

Reset deadlines in accordance to your schedule.
Beginner Level

Beginner Level

Hours to complete

Approx. 20 hours to complete

Suggested: 12 hours/week...
Available languages

English

Subtitles: English...
100% online

100% online

Start instantly and learn at your own schedule.
Flexible deadlines

Flexible deadlines

Reset deadlines in accordance to your schedule.
Beginner Level

Beginner Level

Hours to complete

Approx. 20 hours to complete

Suggested: 12 hours/week...
Available languages

English

Subtitles: English...

Syllabus - What you will learn from this course

Week
1
Hours to complete
1 hour to complete

Course Overview and Data Setup

In this module you learn about the course and you set up the data you need to do the practices in the course. ...
Reading
5 videos (Total 16 min), 4 readings
Video5 videos
Demo: Programming in SAS7m
Practicing in This Coursem
How to Set Up the Course Files in SAS OnDemand for Academics3m
How to Set Up Course Files for SAS University Edition3m
Reading4 readings
Learner Prerequisites10m
Choosing and Setting Up SAS Software for this Course10m
Need Help Setting Up Software?10m
Using Forums and Getting Help10m
Hours to complete
2 hours to complete

Essentials

In this module you learn how to use SAS programming tools and the fundamentals of SAS program structure and syntax. ...
Reading
7 videos (Total 16 min), 2 readings, 3 quizzes
Video7 videos
SAS Programming Interfacesm
Demo: Programming with SAS Studio4m
SAS Program Structure2m
SAS Program Syntaxm
Demo: Understanding SAS Program Syntax2m
Demo: Finding and Resolving Syntax Errors4m
Reading2 readings
Practice Using SAS Studio20m
Syntax Review10m
Quiz3 practice exercises
Activity10m
Activity10m
Essentials30m
Week
2
Hours to complete
3 hours to complete

Accessing Data

In this module, you learn to identify the features of a SAS table, access data through SAS libraries, and import data into SAS....
Reading
14 videos (Total 27 min), 1 reading, 9 quizzes
Video14 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
Reading1 reading
Syntax Review10m
Quiz9 practice exercises
Question5m
Activity10m
Activity10m
Activity: Create a Library for This Course (Required)10m
Activity10m
Activity10m
Level 1 Practice: Importing Excel Data from a Single Worksheet20m
Level 2 Practice: Importing Data from a CSV File20m
Accessing Data30m
Week
3
Hours to complete
5 hours to complete

Exploring and Validating Data

In this module, you learn to use SAS procedures that provide insights about your data. You also learn to subset data so you can focus on particular segments, format data so you can easily understand it, and sort data to identify and resolve duplicate values....
Reading
16 videos (Total 41 min), 1 reading, 14 quizzes
Video16 videos
Exploring Data with Procedures1m
Demo: Exploring Data with SAS Procedures6m
Filtering Rows with the WHERE Statement1m
Combining Expressions in a WHERE Statementm
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 Valuesm
Demo: Formatting Data Values in Results3m
Sorting Data1m
Identifying and Removing Duplicates1m
Demo: Identifying and Removing Duplicate Values5m
Reading1 reading
Syntax Review10m
Quiz14 practice exercises
Activity: Using SAS Documentation10m
Level 1 Practice: Exploring Data with Procedures20m
Level 2 Practice: Using Procedures to Validate Data20m
Activity10m
Activity10m
Activity10m
Level 1 Practice: Filtering Rows in a Listing Report Using Character Data20m
Level 2 Practice: Using Macro Variables to Subset Data in Procedures20m
Activity10m
Activity10m
Activity10m
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
Hours to complete
5 hours to complete

Preparing Data

In this module, you learn how to do some common data manipulations, such as filtering rows and columns, computing new columns, and performing conditional processing....
Reading
13 videos (Total 28 min), 4 readings, 16 quizzes
Video13 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 Columnsm
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
Reading4 readings
Common Summary Functions for Creating Columns5m
Common Character Functions for Creating Columns2m
Common Date Functions for Creating Columns2m
Syntax Review10m
Quiz16 practice exercises
Question5m
Question2m
Activity10m
Level 1 Practice: Creating a SAS Table20m
Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table20m
Activity10m
Activity10m
Activity10m
Level 1 Practice: Creating New Columns20m
Level 2 Practice: Creating New Columns with Character and Date Functions20m
Activity10m
Activity10m
Activity10m
Level 1 Practice: Processing Statements with IF-THEN/ELSE20m
Level 2 Practice: Processing Statements Conditionally with DO Groups20m
Preparing Data30m
4.7
2 ReviewsChevron Right

Top Reviews

By VTNov 12th 2018

A great course to start learning SAS Programming, great examples and practices trough the course.

Instructor

Avatar

Stacey Syphus

Senior Manager
Education

About SAS

Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change....

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.