This course is part of the SAS Programmer Professional Certificate

4.8
stars
2,791 ratings

Stacey Syphus

89,059 already enrolled

Offered By

SAS Programmer Professional CertificateSAS

About this Course

177,482 recent views

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 4 in the

SAS Programmer Professional Certificate

Beginner Level

Approx. 24 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Skills you will gain

SAS Studio
Import Data
Reports
Prepare Data
SAS Programs

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 4 in the

SAS Programmer Professional Certificate

Beginner Level

Approx. 24 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.85/5 (835 Ratings)

Stacey Syphus

Offered by

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.

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

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Content Rating92%(10,253 ratings)

Week1

Week 1

1 hour to complete

Course Overview and Data Setup

1 hour to complete

3 videos (Total 10 min), 3 readings

2 hours to complete

Essentials

2 hours to complete

7 videos (Total 16 min), 2 readings, 3 quizzes

Week2

Week 2

3 hours to complete

Accessing Data

3 hours to complete

14 videos (Total 27 min), 1 reading, 9 quizzes

14 videos

Overview33sTypes of Data1mWhat is a SAS Table?1mRequired Column Attributes for SAS Tables2mListing Table and Column Attributes1mAccessing Data in a Program1mUsing a Library to Read SAS Data3mAutomatic SAS Libraries1mDemo: Exploring Automatic SAS Libraries3mUsing a Library to Read Other File Types2mDemo: Using a Library to Read Excel Files3mImporting Unstructured Data2mDemo: Importing a Comma-Delimited (CSV) File2mImporting an Excel File1m

1 reading

Syntax Review10m

9 practice exercises

Question 2.015mActivity 2.0210mActivity 2.0310mActivity 2.04: Create a Library for This Course (Required)10mActivity 2.0510mActivity 2.0610mLevel 1 Practice: Importing Excel Data from a Single Worksheet20mLevel 2 Practice: Importing Data from a CSV File20mAccessing Data50m

Week3

Week 3

5 hours to complete

Exploring and Validating Data

5 hours to complete

16 videos (Total 40 min), 1 reading, 13 quizzes

16 videos

Overview42sExploring Data with Procedures1mDemo: Exploring Data with SAS Procedures6mFiltering Rows with the WHERE Statement1mCombining Expressions in a WHERE Statement58sDemo: Filtering Rows with Basic Operators5mUsing Special WHERE Operators1mCreating and Using Macro Variables2mDemo: Filtering Rows Using Macro Variables3mFormatting Data Values in Results1mCommon Formats for Numeric Values1mCommon Formats for Date Values26sDemo: Formatting Data Values in Results3mSorting Data1mIdentifying and Removing Duplicates2mDemo: Identifying and Removing Duplicate Values3m

1 reading

Syntax Review10m

13 practice exercises

Activity 3.0110mLevel 1 Practice: Exploring Data with Procedures20mLevel 2 Practice: Using Procedures to Validate Data20mActivity 3.0210mActivity 3.0310mLevel 1 Practice: Filtering Rows in a Listing Report Using Character Data20mLevel 2 Practice: Using Macro Variables to Subset Data in Procedures20mActivity 3.0410mActivity 3.0510mActivity 3.0610mLevel 1 Practice: Sorting Data and Creating an Output Table20mLevel 2 Practice: Sorting Data to Remove Duplicate Rows20mExploring and Validating Data50m

Week4

Week 4

5 hours to complete

Preparing Data

5 hours to complete

13 videos (Total 28 min), 4 readings, 16 quizzes

13 videos

Overview47sUsing the DATA Step to Create a SAS Data Set1mDATA Step Processing1mDemo: Working with the DATA Step3mDemo: Using Expressions to Create New Columns3mUsing Numeric Functions to Create Columns57sDemo: Using Character Functions2mDemo: Using Date Functions3mDemo: Conditional Processing with IF-THEN3mConditional Processing with IF-THEN/ELSE1mCreating Character Columns with the LENGTH Statement1mProcessing Multiple Statements with IF-THEN/DO1mDemo: Processing Multiple Statements with IF-THEN/DO2m

4 readings

Common Summary Functions for Creating Columns5mCommon Character Functions for Creating Columns2mCommon Date Functions for Creating Columns2mSyntax Review10m

16 practice exercises

Question 4.015mQuestion 4.022mActivity 4.0310mLevel 1 Practice: Creating a SAS Table20mLevel 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table20mActivity 4.0410mActivity 4.0510mActivity 4.0610mLevel 1 Practice: Creating New Columns20mLevel 2 Practice: Creating New Columns with Character and Date Functions20mActivity 4.0710mActivity 4.0810mActivity 4.0910mLevel 1 Practice: Processing Statements with IF-THEN/ELSE20mLevel 2 Practice: Processing Statements Conditionally with DO Groups20mPreparing Data50m

Week5

Week 5

4 hours to complete

Analyzing and Reporting on Data

4 hours to complete

11 videos (Total 25 min), 2 readings, 10 quizzes

11 videos

Overview46sUsing Titles and Footnotes1mUsing Macro Variables and Functions in Titles and Footnotes31sApplying Temporary Labels to Columns1mSegmenting Reports39sDemo: Enhancing Reports4mApplying Permanent Labels to Columns20sDemo: Creating Frequency Reports and Graphs7mDemo: Creating Two-Way Frequency Reports4mDemo: Creating a Summary Statistics Report4mCreating an Output Summary Table22s

2 readings

Examples of Procedures that Analyze Data5mSyntax Review10m

10 practice exercises

Activity 5.0110mActivity 5.0310mActivity 5.0410mLevel 1 Practice: Creating One-Way Frequency Reports20mLevel 2 Practice: Creating Two-Way Frequency Reports20mActivity 5.0510mActivity 5.0610mLevel 1 Practice: Producing a Descriptive Statistics Report20mLevel 2 Practice: Creating an Output Table with Custom Columns20mAnalyzing and Reporting on Data50m

Week6

Week 6

3 hours to complete

Exporting Results

3 hours to complete

8 videos (Total 18 min), 3 readings, 6 quizzes

8 videos

Overview28sExporting Data1mDemo: Exporting Data to an Excel Workbook3mUsing the SAS Output Delivery System1mExporting Results to CSV26sDemo: Exporting Results to Excel5mExporting Results to PowerPoint and Microsoft Word30sDemo: Exporting Results to PDF4m

3 readings

Create a Macro Variable (REQUIRED)10mActivity: Create PowerPoint and RTF Files1mSyntax Review10m

6 practice exercises

Activity 6.0110mActivity 6.0210mActivity 6.0310mLevel 1 Practice: Creating an Excel File Using ODS EXCEL20mLevel 2 Practice: Creating a Document with ODS RTF20mExporting Results 50m

2 hours to complete

Using SQL in SAS

2 hours to complete

10 videos (Total 17 min), 1 reading, 4 quizzes

Reviews

4.8

637 reviews

5 stars
85.62%
4 stars
11.97%
3 stars
1.32%
2 stars
0.28%
1 star
0.78%

TOP REVIEWS FROM GETTING STARTED WITH SAS PROGRAMMING

by OLAug 29, 2019

The course is highly recommended for those who just started with SAS programming. Lessons very well organized with a lot of examples. It gives foundation understanding of SAS programming,

by JBAug 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.

by DAJul 16, 2020

Provides an amazing foundation in SAS as a programmer/data analyst! It covers a lot of important topics to get you started using SAS in real world. It exceeded my expectations, highly recommend it!

by SCMar 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.

View all reviews

About the SAS Programmer Professional Certificate

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. 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.
What is the refund policy?
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Getting Started with SAS Programming

About this Course

Skills you will gain