Getting Started with SAS Programming

4.8
stars
1,904 ratings
•
422 reviews

Stacey Syphus

58,969 already enrolled

Offered By

SAS

About this Course

218,997 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.

Learner Career Outcomes

16%

started a new career after completing these courses

22%

got a tangible career benefit from this course

13%

got a pay increase or promotion

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.

Beginner Level

Approx. 22 hours to complete

English

Subtitles: Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, English, Spanish

Instructor

Instructor rating

4.84/5 (478 Ratings)

Stacey Syphus

Learner Career Outcomes

16%

started a new career after completing these courses

22%

got a tangible career benefit from this course

13%

got a pay increase or promotion

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.

Beginner Level

Approx. 22 hours to complete

English

Subtitles: Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, English, Spanish

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.

Syllabus - What you will learn from this course

Content Rating93%(7,477 ratings)

Week

Week 1

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.

1 hour to complete

3 videos (Total 10 min), 3 readings

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.

2 hours to complete

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

Week

Week 2

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.

3 hours to complete

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

14 videos

Overview33s

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

1 reading

Syntax Review10m

9 practice exercises

Question 2.015m

Activity 2.0210m

Activity 2.0310m

Activity 2.04: Create a Library for This Course (Required)10m

Activity 2.0510m

Activity 2.0610m

Level 1 Practice: Importing Excel Data from a Single Worksheet20m

Level 2 Practice: Importing Data from a CSV File20m

Accessing Data30m

Week

Week 3

4 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.

4 hours to complete

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

16 videos

Overview42s

Exploring Data with Procedures1m

Demo: Exploring Data with SAS Procedures6m

Filtering Rows with the WHERE Statement1m

Combining Expressions in a WHERE Statement58s

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 Values26s

Demo: Formatting Data Values in Results3m

Sorting Data1m

Identifying and Removing Duplicates2m

Demo: Identifying and Removing Duplicate Values3m

1 reading

Syntax Review10m

13 practice exercises

Activity 3.0110m

Level 1 Practice: Exploring Data with Procedures20m

Level 2 Practice: Using Procedures to Validate Data20m

Activity 3.0210m

Activity 3.0310m

Level 1 Practice: Filtering Rows in a Listing Report Using Character Data20m

Level 2 Practice: Using Macro Variables to Subset Data in Procedures20m

Activity 3.0410m

Activity 3.0510m

Activity 3.0610m

Level 1 Practice: Sorting Data and Creating an Output Table20m

Level 2 Practice: Sorting Data to Remove Duplicate Rows20m

Exploring and Validating Data30m

Week

Week 4

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.

5 hours to complete

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

13 videos

Overview47s

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 Columns57s

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

4 readings

Common Summary Functions for Creating Columns5m

Common Character Functions for Creating Columns2m

Common Date Functions for Creating Columns2m

Syntax Review10m

16 practice exercises

Question 4.015m

Question 4.022m

Activity 4.0310m

Level 1 Practice: Creating a SAS Table20m

Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table20m

Activity 4.0410m

Activity 4.0510m

Activity 4.0610m

Level 1 Practice: Creating New Columns20m

Level 2 Practice: Creating New Columns with Character and Date Functions20m

Activity 4.0710m

Activity 4.0810m

Activity 4.0910m

Level 1 Practice: Processing Statements with IF-THEN/ELSE20m

Level 2 Practice: Processing Statements Conditionally with DO Groups20m

Preparing Data30m

Week

Week 5

4 hours to complete

Analyzing and Reporting on Data

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.

4 hours to complete

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

11 videos

Overview46s

Using Titles and Footnotes1m

Using Macro Variables and Functions in Titles and Footnotes31s

Applying Temporary Labels to Columns1m

Segmenting Reports39s

Demo: Enhancing Reports4m

Applying Permanent Labels to Columns20s

Demo: Creating Frequency Reports and Graphs7m

Demo: Creating Two-Way Frequency Reports4m

Demo: Creating a Summary Statistics Report4m

Creating an Output Summary Table22s

2 readings

Examples of Procedures that Analyze Data5m

Syntax Review10m

10 practice exercises

Activity 5.0110m

Activity 5.0310m

Activity 5.0410m

Level 1 Practice: Creating One-Way Frequency Reports20m

Level 2 Practice: Creating Two-Way Frequency Reports20m

Activity 5.0510m

Activity 5.0610m

Level 1 Practice: Producing a Descriptive Statistics Report20m

Level 2 Practice: Creating an Output Table with Custom Columns20m

Analyzing and Reporting on Data30m

Week

Week 6

2 hours to complete

Exporting Results

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

2 hours to complete

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

8 videos

Overview28s

Exporting Data1m

Demo: Exporting Data to an Excel Workbook3m

Using the SAS Output Delivery System1m

Exporting Results to CSV26s

Demo: Exporting Results to Excel5m

Exporting Results to PowerPoint and Microsoft Word30s

Demo: Exporting Results to PDF4m

3 readings

Create a Macro Variable (REQUIRED)10m

Activity: Create PowerPoint and RTF Files1m

Syntax Review10m

6 practice exercises

Activity 6.0110m

Activity 6.0210m

Activity 6.0310m

Level 1 Practice: Creating an Excel File Using ODS EXCEL20m

Level 2 Practice: Creating a Document with ODS RTF20m

Exporting Results30m

2 hours to complete

Using SQL in SAS

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.

2 hours to complete

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

Reviews

4.8

422 reviews

5 stars
86.70%
4 stars
11.20%
3 stars
1.20%
2 stars
0.15%
1 star
0.73%

TOP REVIEWS FROM GETTING STARTED WITH SAS PROGRAMMING

by HHJul 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 BMFeb 20, 2019

This course offers a solid foundation to anyone who is interested in beginning to use SAS. I have found the demos, activites and practices to be fairly easy yet still required me to use my brain.

by SKMay 13, 2020

Simple, Straight to the point, Engages learners with tiny quizzes to help in learning actively. Could have more reading material as optional to dive deeper though. Overall, Great beginner course.

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

View all reviews

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.
Will I earn university credit for completing the Course?
This Course doesn't carry university credit, but some universities may choose to accept Course Certificates for credit. Check with your institution to learn more. Online Degrees and Mastertrack™ Certificates on Coursera provide the opportunity to earn university credit.

More questions? Visit the Learner Help Center.

Getting Started with SAS Programming

About this Course

Learner Career Outcomes

16%

22%

13%

Instructor

Stacey Syphus

Learner Career Outcomes

16%

22%

13%

Offered by

SAS

Syllabus - What you will learn from this course

Week 1

Course Overview and Data Setup

Essentials

Week 2

Accessing Data

Week 3

Exploring and Validating Data

Week 4

Preparing Data

Week 5

Analyzing and Reporting on Data

Week 6

Exporting Results

Using SQL in SAS

Reviews

TOP REVIEWS FROM GETTING STARTED WITH SAS PROGRAMMING

Frequently Asked Questions

Start or advance your career

Browse popular topics

Upskill your team

Earn a degree or certificate online

Coursera

Community

More

Getting Started with SAS Programming

About this Course

Learner Career Outcomes

16%

22%

13%

Instructor

Stacey Syphus

Learner Career Outcomes

16%

22%

13%

Offered by

SAS

Syllabus - What you will learn from this course

Week 1

Course Overview and Data Setup

Essentials

Week 2

Accessing Data

Week 3

Exploring and Validating Data

Week 4

Preparing Data

Week 5

Analyzing and Reporting on Data

Week 6

Exporting Results

Using SQL in SAS

Reviews

TOP REVIEWS FROM GETTING STARTED WITH SAS PROGRAMMING

Frequently Asked Questions

Coursera Footer

Start or advance your career

Browse popular topics

Upskill your team

Earn a degree or certificate online

Coursera

Community

More