Getting Started with SAS Programming

This course is part of SAS Programmer Professional Certificate

Instructor: Stacey Syphus

Access provided by UBS Business Solutions AG

118,526 already enrolled

8 modules

Gain insight into a topic and learn the fundamentals.

3,178 reviews

Beginner level

No prior experience required

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

90%

Most learners liked this course

8 modules

Gain insight into a topic and learn the fundamentals.

3,178 reviews

Beginner level

No prior experience required

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

90%

Most learners liked this course

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

59 assignments

Taught in English

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

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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

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 videos4 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 assignments

7 videos Total 16 minutes

Overview: Essentials 0 minutes
SAS Programming Interfaces 1 minute
Demo: Programming with SAS Studio 4 minutes
SAS Program Structure 3 minutes
SAS Program Syntax 1 minute
Demo: Understanding SAS Program Syntax 2 minutes
Demo: Finding and Resolving Syntax Errors 4 minutes

2 readings Total 30 minutes

Practice Using SAS Studio 20 minutes
Syntax Review: Essentials 10 minutes

3 assignments Total 65 minutes

Essentials Review 45 minutes
Activity 1.1 10 minutes
Activity 1.2 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 reading8 assignments

14 videos Total 27 minutes

Overview: Accessing Data 1 minute
Types of Data 1 minute
What is a SAS Table? 1 minute
Required Column Attributes for SAS Tables 3 minutes
Listing Table and Column Attributes 1 minute
Accessing Data in a Program 1 minute
Using a Library to Read SAS Data 3 minutes
Automatic SAS Libraries 1 minute
Demo: Exploring Automatic SAS Libraries 3 minutes
Using a Library to Read Other File Types 3 minutes
Demo: Using a Library to Read Excel Files 3 minutes
Importing Unstructured Data 2 minutes
Demo: Importing a Comma-Delimited (CSV) File 2 minutes
Importing an Excel File 1 minute

1 reading Total 10 minutes

Syntax Review: Accessing Data 10 minutes

8 assignments Total 140 minutes

Accessing Data 50 minutes
Activity 2.1 10 minutes
Activity 2.2 10 minutes
Activity 2.3: Create a Library for this Course (Required) 10 minutes
Activity 2.4 10 minutes
Activity 2.5 10 minutes
Level 1 Practice: Importing Excel Data from a Single Worksheet 20 minutes
Level 2 Practice: Importing Data from a CSV File 20 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 assignments

16 videos Total 40 minutes

Overview: Exploring and Validating Data 1 minute
Exploring Data with Procedures 1 minute
Demo: Exploring Data with SAS Procedures 7 minutes
Filtering Rows with the WHERE Statement 2 minutes
Combining Expressions in a WHERE Statement 1 minute
Demo: Filtering Rows with Basic Operators 6 minutes
Using Special WHERE Operators 1 minute
Creating and Using Macro Variables 2 minutes
Demo: Filtering Rows Using Macro Variables 4 minutes
Formatting Data Values in Results 2 minutes
Common Formats for Numeric Values 2 minutes
Common Formats for Date Values 0 minutes
Demo: Formatting Data Values in Results 3 minutes
Sorting Data 2 minutes
Identifying and Removing Duplicates 2 minutes
Demo: Identifying and Removing Duplicate Values 4 minutes

1 reading Total 10 minutes

Syntax Review: Exploring and Validating Data 10 minutes

13 assignments Total 210 minutes

Exploring and Validating Data 50 minutes
Activity 3.1 10 minutes
Level 1 Practice: Exploring Data with Procedures 20 minutes
Level 2 Practice: Using Procedures to Validate Data 20 minutes
Activity 3.2 10 minutes
Activity 3.3 10 minutes
Level 1 Practice: Filtering Rows in a Listing Report Using Character Data 10 minutes
Level 2 Practice: Using Macro Variables to Subset Data in Procedures 20 minutes
Activity 3.4 10 minutes
Activity 3.5 10 minutes
Activity 3.6 10 minutes
Level 1 Practice: Sorting Data and Creating an Output Table 20 minutes
Level 2 Practice: Sorting Data to Remove Duplicate Rows 10 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 readings14 assignments

13 videos Total 28 minutes

Overview: Preparing Data 1 minute
Using the DATA Step to Create a SAS Data Set 1 minute
DATA Step Processing 1 minute
Demo: Working with the DATA Step 3 minutes
Demo: Using Expressions to Create New Columns 3 minutes
Using Numeric Functions to Create Columns 1 minute
Demo: Using Character Functions 3 minutes
Demo: Using Date Functions 4 minutes
Demo: Conditional Processing with IF-THEN 4 minutes
Conditional Processing with IF-THEN/ELSE 2 minutes
Creating Character Columns with the LENGTH Statement 1 minute
Processing Multiple Statements with IF-THEN/DO 2 minutes
Demo: Processing Multiple Statements with IF-THEN/DO 3 minutes

4 readings Total 19 minutes

Common Summary Functions for Creating Columns 5 minutes
Common Character Functions for Creating Columns 2 minutes
Common Date Functions for Creating Columns 2 minutes
Syntax Review: Preparing Data 10 minutes

14 assignments Total 240 minutes

Preparing Data 50 minutes
Activity 4.1 10 minutes
Level 1 Practice: Creating a SAS Table 20 minutes
Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table 20 minutes
Activity 4.2 10 minutes
Activity 4.3 10 minutes
Activity 4.4 10 minutes
Level 1 Practice: Creating New Columns 20 minutes
Level 2 Practice: Creating New Columns with Character and Date Functions 20 minutes
Activity 4.5 10 minutes
Activity 4.6 10 minutes
Activity 4.7 10 minutes
Level 1 Practice: Processing Statements with IF-THEN/ELSE 20 minutes
Level 2 Practice: Processing Statements Conditionally with DO Groups 20 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 assignments

11 videos Total 25 minutes

Overview: Analyzing and Reporting on Data 1 minute
Using Titles and Footnotes 2 minutes
Using Macro Variables and Functions in Titles and Footnotes 1 minute
Applying Temporary Labels to Columns 1 minute
Segmenting Reports 1 minute
Demo: Enhancing Reports 4 minutes
Applying Permanent Labels to Columns 0 minutes
Demo: Creating Frequency Reports and Graphs 7 minutes
Demo: Creating Two-Way Frequency Reports 4 minutes
Demo: Creating a Summary Statistics Report 5 minutes
Creating an Output Summary Table 0 minutes

2 readings Total 15 minutes

Examples of Procedures that Analyze Data 5 minutes
Syntax Review: Analyzing and Reporting on Data 10 minutes

10 assignments Total 170 minutes

Analyzing and Reporting on Data 50 minutes
Activity 5.1 10 minutes
Activity 5.2 10 minutes
Activity 5.3 10 minutes
Level 1 Practice: Creating One-Way Frequency Reports 20 minutes
Level 2 Practice: Creating Two-Way Frequency Reports 20 minutes
Activity 5.4 10 minutes
Activity 5.5 10 minutes
Level 1 Practice: Producing a Descriptive Statistics Report 10 minutes
Level 2 Practice: Creating an Output Table with Custom Columns 20 minutes

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

What's included

8 videos2 readings7 assignments

8 videos Total 18 minutes

Overview: Exporting Results 0 minutes
Exporting Data 2 minutes
Demo: Exporting Data to an Excel Workbook 4 minutes
Using the SAS Output Delivery System 2 minutes
Exporting Results to CSV 0 minutes
Demo: Exporting Results to Excel 5 minutes
Exporting Results to PowerPoint and Microsoft Word 1 minute
Demo: Exporting Results to PDF 4 minutes

2 readings Total 11 minutes

Activity: Create PowerPoint and RTF Files 1 minute
Syntax Review: Exporting Results 10 minutes

7 assignments Total 115 minutes

Exporting Results 50 minutes
Create a Macro Variable (REQUIRED) 5 minutes
Activity 6.1 10 minutes
Activity 6.2 10 minutes
Activity 6.3 10 minutes
Level 1 Practice: Creating an Excel File Using ODS EXCEL 15 minutes
Level 2 Practice: Creating a Document with ODS RTF 15 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 assignments

10 videos Total 17 minutes

Overview: Using SQL in SAS 1 minute
SQL and SAS 2 minutes
PROC SQL Syntax 2 minutes
Filtering and Sorting Output 1 minute
Demo: Reading and Filtering Data with SQL 4 minutes
Creating and Deleting Tables in SQL 1 minute
Creating Inner Joins in SQL 2 minutes
Demo: Joining Tables with PROC SQL 4 minutes
Using Table Aliases 0 minutes
You've Finished the Course! 0 minutes

1 reading Total 10 minutes

Syntax Review: Using SQL in SAS 10 minutes

4 assignments Total 80 minutes

Using SQL in SAS 50 minutes
Activity 7.1 10 minutes
Activity 7.2 10 minutes
Activity 7.3 10 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(957 ratings)

Stacey Syphus

SAS

8 Courses 128,470 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

5 stars
84.86%
4 stars
12.52%
3 stars
1.35%
2 stars
0.31%
1 star
0.94%

Showing 3 of 3178

Reviewed on Aug 29, 2020

I really felt like I learned a lot. The class was well organized with great examples and activities. I would highly recommend this course. I plan on taking the next series of classes.

Reviewed on Mar 29, 2021

Great course and awesome instructor. Learned a lot about some SAS capabilities, syntaxes, and others. Highly recommend this course if you would like to start getting to know SAS programming.

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.

View more reviews