Getting Started with SAS Programming

This course is part of SAS Programmer Professional Certificate

Instructor: Stacey Syphus

Sponsored by Louisiana Workforce Commission

109,594 already enrolled

8 modules

Gain insight into a topic and learn the fundamentals.

4.8

(3,080 reviews)

Beginner level

No prior experience required

Flexible schedule

Approx. 24 hours

Learn at your own pace

90%

Most learners liked this course

8 modules

Gain insight into a topic and learn the fundamentals.

4.8

(3,080 reviews)

Beginner level

No prior experience required

Flexible schedule

Approx. 24 hours

Learn at your own pace

90%

Most learners liked this course

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

61 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your Data Analysis expertise

This course is part of the SAS Programmer Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from SAS

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 8 modules in this course

This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses.

By the end of this course, you will know how to use SAS Studio to write and submit SAS programs that access SAS, Microsoft Excel, and text data. You will know how to explore and validate data, prepare data by subsetting rows and computing new columns, analyze and report on data, export data and results to other formats, use SQL in SAS to query and join tables. Prerequisites: Learners should have experience using computer software. Specifically, you should be able to understand file structures and system commands on your operating systems and access data files on your operating systems. No prior SAS experience is needed.

In this module you learn about the course and you set up the data you need to do the practices in the course.

What's included

3 videos3 readings

In this module you learn how to use SAS programming tools and the fundamentals of SAS program structure and syntax.

What's included

7 videos2 readings3 assignments1 discussion prompt

7 videosTotal 15 minutes

Overview0 minutesPreview module
SAS Programming Interfaces0 minutes
Demo: Programming with SAS Studio4 minutes
SAS Program Structure2 minutes
SAS Program Syntax0 minutes
Demo: Understanding SAS Program Syntax2 minutes
Demo: Finding and Resolving Syntax Errors4 minutes

2 readingsTotal 30 minutes

Practice Using SAS Studio20 minutes
Syntax Review10 minutes

3 assignmentsTotal 65 minutes

Essentials Review45 minutes
Activity 1.0110 minutes
Activity 1.0210 minutes

1 discussion promptTotal 10 minutes

Your turn - Are you new to programming?10 minutes

In this module, you learn to identify the features of a SAS table, access data through SAS libraries, and import data into SAS.

What's included

14 videos1 reading9 assignments2 discussion prompts

14 videosTotal 26 minutes

Overview0 minutesPreview module
Types of Data1 minute
What is a SAS Table?1 minute
Required Column Attributes for SAS Tables2 minutes
Listing Table and Column Attributes1 minute
Accessing Data in a Program1 minute
Using a Library to Read SAS Data3 minutes
Automatic SAS Libraries1 minute
Demo: Exploring Automatic SAS Libraries3 minutes
Using a Library to Read Other File Types2 minutes
Demo: Using a Library to Read Excel Files3 minutes
Importing Unstructured Data2 minutes
Demo: Importing a Comma-Delimited (CSV) File2 minutes
Importing an Excel File1 minute

1 readingTotal 10 minutes

Syntax Review10 minutes

9 assignmentsTotal 145 minutes

Accessing Data50 minutes
Question 2.015 minutes
Activity 2.0210 minutes
Activity 2.0310 minutes
Activity 2.04: Create a Library for This Course (Required)10 minutes
Activity 2.0510 minutes
Activity 2.0610 minutes
Level 1 Practice: Importing Excel Data from a Single Worksheet20 minutes
Level 2 Practice: Importing Data from a CSV File20 minutes

2 discussion promptsTotal 20 minutes

Your turn - Do you understand SAS libraries?10 minutes
Your turn - What type of data do you have?10 minutes

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.

What's included

16 videos1 reading13 assignments1 discussion prompt

16 videosTotal 39 minutes

Overview0 minutesPreview module
Exploring Data with Procedures1 minute
Demo: Exploring Data with SAS Procedures6 minutes
Filtering Rows with the WHERE Statement1 minute
Combining Expressions in a WHERE Statement0 minutes
Demo: Filtering Rows with Basic Operators5 minutes
Using Special WHERE Operators1 minute
Creating and Using Macro Variables2 minutes
Demo: Filtering Rows Using Macro Variables3 minutes
Formatting Data Values in Results1 minute
Common Formats for Numeric Values1 minute
Common Formats for Date Values0 minutes
Demo: Formatting Data Values in Results3 minutes
Sorting Data1 minute
Identifying and Removing Duplicates2 minutes
Demo: Identifying and Removing Duplicate Values3 minutes

1 readingTotal 10 minutes

Syntax Review10 minutes

13 assignmentsTotal 230 minutes

Exploring and Validating Data50 minutes
Activity 3.0110 minutes
Level 1 Practice: Exploring Data with Procedures20 minutes
Level 2 Practice: Using Procedures to Validate Data20 minutes
Activity 3.0210 minutes
Activity 3.0310 minutes
Level 1 Practice: Filtering Rows in a Listing Report Using Character Data20 minutes
Level 2 Practice: Using Macro Variables to Subset Data in Procedures20 minutes
Activity 3.0410 minutes
Activity 3.0510 minutes
Activity 3.0610 minutes
Level 1 Practice: Sorting Data and Creating an Output Table 20 minutes
Level 2 Practice: Sorting Data to Remove Duplicate Rows20 minutes

1 discussion promptTotal 10 minutes

Your turn - What you learned in this module10 minutes

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.

What's included

13 videos4 readings16 assignments1 discussion prompt

13 videosTotal 28 minutes

Overview0 minutesPreview module
Using the DATA Step to Create a SAS Data Set1 minute
DATA Step Processing1 minute
Demo: Working with the DATA Step3 minutes
Demo: Using Expressions to Create New Columns3 minutes
Using Numeric Functions to Create Columns0 minutes
Demo: Using Character Functions2 minutes
Demo: Using Date Functions3 minutes
Demo: Conditional Processing with IF-THEN3 minutes
Conditional Processing with IF-THEN/ELSE1 minute
Creating Character Columns with the LENGTH Statement1 minute
Processing Multiple Statements with IF-THEN/DO1 minute
Demo: Processing Multiple Statements with IF-THEN/DO2 minutes

4 readingsTotal 19 minutes

Common Summary Functions for Creating Columns5 minutes
Common Character Functions for Creating Columns2 minutes
Common Date Functions for Creating Columns2 minutes
Syntax Review10 minutes

16 assignmentsTotal 247 minutes

Preparing Data50 minutes
Question 4.015 minutes
Question 4.022 minutes
Activity 4.0310 minutes
Level 1 Practice: Creating a SAS Table20 minutes
Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table20 minutes
Activity 4.0410 minutes
Activity 4.0510 minutes
Activity 4.0610 minutes
Level 1 Practice: Creating New Columns20 minutes
Level 2 Practice: Creating New Columns with Character and Date Functions20 minutes
Activity 4.0710 minutes
Activity 4.0810 minutes
Activity 4.0910 minutes
Level 1 Practice: Processing Statements with IF-THEN/ELSE20 minutes
Level 2 Practice: Processing Statements Conditionally with DO Groups20 minutes

1 discussion promptTotal 10 minutes

Your turn - Using Functions10 minutes

In this module, we concentrate on summarizing data by using the SAS procedures that we touched on for data exploration. You also learn how to use titles, column labels, footnotes, and macro variables to enhance your reports and make them more meaningful.

What's included

11 videos2 readings10 assignments1 discussion prompt

11 videosTotal 25 minutes

Overview0 minutesPreview module
Using Titles and Footnotes1 minute
Using Macro Variables and Functions in Titles and Footnotes0 minutes
Applying Temporary Labels to Columns1 minute
Segmenting Reports0 minutes
Demo: Enhancing Reports4 minutes
Applying Permanent Labels to Columns0 minutes
Demo: Creating Frequency Reports and Graphs7 minutes
Demo: Creating Two-Way Frequency Reports4 minutes
Demo: Creating a Summary Statistics Report4 minutes
Creating an Output Summary Table0 minutes

2 readingsTotal 15 minutes

Examples of Procedures that Analyze Data5 minutes
Syntax Review10 minutes

10 assignmentsTotal 180 minutes

Analyzing and Reporting on Data50 minutes
Activity 5.0110 minutes
Activity 5.0310 minutes
Activity 5.0410 minutes
Level 1 Practice: Creating One-Way Frequency Reports20 minutes
Level 2 Practice: Creating Two-Way Frequency Reports20 minutes
Activity 5.0510 minutes
Activity 5.0610 minutes
Level 1 Practice: Producing a Descriptive Statistics Report20 minutes
Level 2 Practice: Creating an Output Table with Custom Columns20 minutes

1 discussion promptTotal 10 minutes

Your turn - What analyses will you use?10 minutes

In this module, you learn to export SAS tables and results to Excel, Microsoft Word, and PDF files.

What's included

8 videos3 readings6 assignments1 discussion prompt

8 videosTotal 18 minutes

Overview0 minutesPreview module
Exporting Data1 minute
Demo: Exporting Data to an Excel Workbook3 minutes
Using the SAS Output Delivery System1 minute
Exporting Results to CSV0 minutes
Demo: Exporting Results to Excel5 minutes
Exporting Results to PowerPoint and Microsoft Word0 minutes
Demo: Exporting Results to PDF4 minutes

3 readingsTotal 21 minutes

Create a Macro Variable (REQUIRED)10 minutes
Activity: Create PowerPoint and RTF Files1 minute
Syntax Review10 minutes

6 assignmentsTotal 120 minutes

Exporting Results 50 minutes
Activity 6.0110 minutes
Activity 6.0210 minutes
Activity 6.0310 minutes
Level 1 Practice: Creating an Excel File Using ODS EXCEL20 minutes
Level 2 Practice: Creating a Document with ODS RTF20 minutes

1 discussion promptTotal 10 minutes

Your turn - Exporting Data and Results10 minutes

In this module, you learn to use the SQL procedure to read and filter data. You also learn to create and join tables by using SQL.

What's included

10 videos1 reading4 assignments2 discussion prompts

10 videosTotal 16 minutes

Overview0 minutesPreview module
SQL and SAS1 minute
PROC SQL Syntax1 minute
Filtering and Sorting Output1 minute
Demo: Reading and Filtering Data with SQL4 minutes
Creating and Deleting Tables in SQL0 minutes
Creating Inner Joins in SQL2 minutes
Demo: Joining Tables with PROC SQL4 minutes
Using Table Aliases0 minutes
You've Finished the Course!0 minutes

1 readingTotal 10 minutes

Syntax Review10 minutes

4 assignmentsTotal 80 minutes

Using SQL in SAS50 minutes
Activity 7.0110 minutes
Activity 7.0210 minutes
Activity 7.0310 minutes

2 discussion promptsTotal 20 minutes

Your turn - Do you have SQL experience?10 minutes
Your turn - Let Us Know!10 minutes

Instructor

Instructor ratings

4.9 (927 ratings)

Stacey Syphus

SAS

8 Courses118,900 learners

Offered by

SAS

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

4.8

3,080 reviews

5 stars
85.15%
4 stars
12.31%
3 stars
1.29%
2 stars
0.29%
1 star
0.94%

Showing 3 of 3080

Reviewed on Jul 25, 2020

I feel I now have a solid understanding of most of the basics of SAS. If you're planning on taking this course, I highly suggest printing out the review pages and annotating as you go along.

Reviewed on Sep 30, 2020

This course provides a foundational curriculum for anyone just starting with SAS. There are hands-on activities after every video which helps solidify the concepts really well. Loved it!

Reviewed on Jun 14, 2023

I think the course material and the SAS practices/activities/demos were very helpful, however, I didn't like the style of the quiz questions which was very different from the practices.

View more reviews