Getting Started with SAS Programming

This course is part of SAS Programmer Professional Certificate

Instructor: Stacey Syphus

Access provided by DAVIbank y BNP Paribas Cardif

119,128 already enrolled

8 modules

Gain insight into a topic and learn the fundamentals.

3,180 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,180 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 videosTotal 16 minutes

Overview: Essentials0 minutes
SAS Programming Interfaces1 minute
Demo: Programming with SAS Studio4 minutes
SAS Program Structure3 minutes
SAS Program Syntax1 minute
Demo: Understanding SAS Program Syntax2 minutes
Demo: Finding and Resolving Syntax Errors4 minutes

2 readingsTotal 30 minutes

Practice Using SAS Studio20 minutes
Syntax Review: Essentials10 minutes

3 assignmentsTotal 65 minutes

Essentials Review45 minutes
Activity 1.110 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 videosTotal 27 minutes

Overview: Accessing Data1 minute
Types of Data1 minute
What is a SAS Table?1 minute
Required Column Attributes for SAS Tables3 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 Types3 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 Review: Accessing Data10 minutes

8 assignmentsTotal 140 minutes

Accessing Data50 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.510 minutes
Level 1 Practice: Importing Excel Data from a Single Worksheet 20 minutes
Level 2 Practice: Importing Data from a CSV File20 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 videosTotal 40 minutes

Overview: Exploring and Validating Data1 minute
Exploring Data with Procedures1 minute
Demo: Exploring Data with SAS Procedures7 minutes
Filtering Rows with the WHERE Statement2 minutes
Combining Expressions in a WHERE Statement1 minute
Demo: Filtering Rows with Basic Operators6 minutes
Using Special WHERE Operators1 minute
Creating and Using Macro Variables2 minutes
Demo: Filtering Rows Using Macro Variables4 minutes
Formatting Data Values in Results2 minutes
Common Formats for Numeric Values2 minutes
Common Formats for Date Values0 minutes
Demo: Formatting Data Values in Results3 minutes
Sorting Data2 minutes
Identifying and Removing Duplicates2 minutes
Demo: Identifying and Removing Duplicate Values4 minutes

1 readingTotal 10 minutes

Syntax Review: Exploring and Validating Data10 minutes

13 assignmentsTotal 210 minutes

Exploring and Validating Data50 minutes
Activity 3.1 10 minutes
Level 1 Practice: Exploring Data with Procedures20 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 Procedures20 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 videosTotal 28 minutes

Overview: Preparing Data1 minute
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 Columns1 minute
Demo: Using Character Functions3 minutes
Demo: Using Date Functions4 minutes
Demo: Conditional Processing with IF-THEN4 minutes
Conditional Processing with IF-THEN/ELSE2 minutes
Creating Character Columns with the LENGTH Statement1 minute
Processing Multiple Statements with IF-THEN/DO2 minutes
Demo: Processing Multiple Statements with IF-THEN/DO3 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 Review: Preparing Data10 minutes

14 assignmentsTotal 240 minutes

Preparing Data50 minutes
Activity 4.110 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.410 minutes
Level 1 Practice: Creating New Columns 20 minutes
Level 2 Practice: Creating New Columns with Character and Date Functions 20 minutes
Activity 4.510 minutes
Activity 4.610 minutes
Activity 4.710 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 videosTotal 25 minutes

Overview: Analyzing and Reporting on Data1 minute
Using Titles and Footnotes2 minutes
Using Macro Variables and Functions in Titles and Footnotes1 minute
Applying Temporary Labels to Columns1 minute
Segmenting Reports1 minute
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 Report5 minutes
Creating an Output Summary Table0 minutes

2 readingsTotal 15 minutes

Examples of Procedures that Analyze Data5 minutes
Syntax Review: Analyzing and Reporting on Data10 minutes

10 assignmentsTotal 170 minutes

Analyzing and Reporting on Data50 minutes
Activity 5.110 minutes
Activity 5.2 10 minutes
Activity 5.310 minutes
Level 1 Practice: Creating One-Way Frequency Reports 20 minutes
Level 2 Practice: Creating Two-Way Frequency Reports20 minutes
Activity 5.410 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 videosTotal 18 minutes

Overview: Exporting Results0 minutes
Exporting Data2 minutes
Demo: Exporting Data to an Excel Workbook4 minutes
Using the SAS Output Delivery System2 minutes
Exporting Results to CSV0 minutes
Demo: Exporting Results to Excel5 minutes
Exporting Results to PowerPoint and Microsoft Word1 minute
Demo: Exporting Results to PDF4 minutes

2 readingsTotal 11 minutes

Activity: Create PowerPoint and RTF Files1 minute
Syntax Review: Exporting Results10 minutes

7 assignmentsTotal 115 minutes

Exporting Results 50 minutes
Create a Macro Variable (REQUIRED)5 minutes
Activity 6.110 minutes
Activity 6.210 minutes
Activity 6.310 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 videosTotal 17 minutes

Overview: Using SQL in SAS1 minute
SQL and SAS2 minutes
PROC SQL Syntax2 minutes
Filtering and Sorting Output1 minute
Demo: Reading and Filtering Data with SQL4 minutes
Creating and Deleting Tables in SQL1 minute
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 Review: Using SQL in SAS10 minutes

4 assignmentsTotal 80 minutes

Using SQL in SAS50 minutes
Activity 7.1 10 minutes
Activity 7.210 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 Courses129,096 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.87%
4 stars
12.51%
3 stars
1.35%
2 stars
0.31%
1 star
0.94%

Showing 3 of 3180

Reviewed on Jun 29, 2020

This was an excellent course. Meticulously planned for a beginner with no much knowledge on SAS. However basic programming logic or knowledge is highly useful. This course has benefited me a lot.

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 Aug 18, 2020

The course is extremely well structured, has great inputs from the instructor; the activities and demos are comprehensive, and constantly made me excited about completing the course!

View more reviews