This course is part of the SAS Programmer Professional Certificate

4.8
stars
872 ratings

Stacey Syphus

26,815 already enrolled

Offered By

SAS Programmer Professional CertificateSAS

About this Course

58,413 recent views

This course is for business analysts and SAS programmers who want to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the Getting Started with SAS Programming course and is not recommended for beginning SAS software users.
In this course you learn how to understand and control DATA step processing, create an accumulating column and process data in groups, manipulate data with functions, convert column type, create custom formats, concatenate and merge tables, process repetitive code, and restructure tables. This course addresses Base SAS software.

Before attending this course, you should be able to write DATA step code to access data, subset rows and columns, compute new columns, and process data conditionally. You should also be able to sort tables using the SORT procedure and
apply SAS formats.

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 2 of 4 in the

SAS Programmer Professional Certificate

Intermediate Level

Approx. 25 hours to complete

English

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

Try Coursera for Business

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 2 of 4 in the

SAS Programmer Professional Certificate

Intermediate Level

Approx. 25 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 (167 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 Rating96%(3,491 ratings)

Week1

Week 1

24 minutes to complete

Course Overview and Data Setup

24 minutes to complete

2 videos (Total 1 min), 3 readings

2 hours to complete

Controlling DATA Step Processing

2 hours to complete

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

14 videos

Overview15sDATA Step Review30sDATA Step Processing55sDATA Step Processing: Compilation3mDATA Step Processing: Execution1mDemo: DATA Step Processing in Action5mViewing Execution in the Log1mControlling DATA Step Processing1mImplicit and Explicit Output1mSending Output to Multiple Tables26sDemo: Directing Row Output3mControlling Column Output30sDemo: Directing Column Output3mColumns in the PDV36s

1 reading

Syntax Review10m

9 practice exercises

Activity 1.0110mActivity 1.0210mPractice: Using PUTLOG Statements to Examine Execution Steps20mActivity 1.0310mActivity 1.0410mQuestion 1.055mLevel 1 Practice: Conditionally Creating Multiple Output Tables20mLevel 2 Practice: Conditionally Creating Columns and Output Tables20mControlling DATA Step Processing

Week2

Week 2

3 hours to complete

Summarizing Data

3 hours to complete

10 videos (Total 19 min), 1 reading, 11 quizzes

10 videos

Overview20sDemo: Creating an Accumulating Column3mRetaining Values in the PDV1mUsing the Sum Statement58sAnswering Questions about Groups42sProcessing Sorted Data in Groups1mDemo: Identifying the First and Last Row in Each Group4mSubsetting Rows in the Execution Phase2mDemo: Creating an Accumulating Column within Groups2mUsing Multiple BY Columns1m

1 reading

Syntax Review10m

11 practice exercises

Activity 2.0110mQuestion 2.025mLevel 1 Practice: Producing a Running Total20mLevel 2 Practice: Producing Multiple Totals20mActivity 2.0310mActivity 2.0410mActivity 2.0510mQuestion 2.065mLevel 1 Practice: Generating an Accumulating Column within Groups20mLevel 2 Practice: Generating an Accumulating Column within Multiple Groups20mSummarizing Data50m

Week3

Week 3

6 hours to complete

Manipulating Data with Functions

6 hours to complete

24 videos (Total 40 min), 5 readings, 18 quizzes

24 videos

Overview15sReview of Functions44sSpecifying Columns Lists1mUsing a CALL Routine to Modify Data1mUsing Numeric Functions1mDemo: Using Numeric Functions2mSAS Date, Datetime, and Time Values53sExtracting Data from a Datetime Value29sCalculating Date Intervals2mShifting Date Values50sDemo: Shifting Date Values Based on an Interval3mUseful Character Functions53sExtracting Words from a String58sDemo: Using Character Functions to Extract Words from a String3mSearching for Character Strings51sReplacing Character Strings27sHandling Column Type35sConverting Column Type1mConverting Character Values to Numeric Values1mUsing a Generic Informat to Read Dates1mConverting the Type of an Existing Column1mConverting Numeric Values to Character Values1mDemo: Using the INPUT Function to Convert Column Types7mDemo: Using the PUT Function to Convert Column Types3m

5 readings

Using Numeric Functions to Change Precision10mRemoving Characters from a String10mIdentifying Character Positions10mBuilding Character Strings10mSyntax Review10m

18 practice exercises

Activity 3.0110mActivity 3.0210mActivity 3.0310mActivity 3.0410mQuestion 3.055mLevel 1 Practice: Using the LARGEST and ROUND Functions20mLevel 2 Practice: Working with Date/Time Values20mActivity 3.0610mActivity 3.0710mActivity 3.0810mActivity 3.0910mLevel 1 Practice: Using the SCAN and PROPCASE Functions20mLevel 2 Practice: Searching for Character Strings20mActivity 3.1010mActivity 3.1110mQuestion 3.125mActivity 3.1310mManipulating Data with Functions50m

Week4

Week 4

4 hours to complete

Creating and Using Custom Formats

4 hours to complete

8 videos (Total 16 min), 1 reading, 10 quizzes

8 videos

Overview9sFormatting Data Values28sCreating and Applying a Custom Format2mUsing Ranges1mDemo: Creating and Using Custom Formats3mReading a Table of Values for a Format2mDemo: Creating Custom Formats from Tables4mStoring Custom Formats1m

1 reading

Syntax Review10m

10 practice exercises

Activity 4.0110mActivity 4.0210mActivity 4.0310mLevel 1 Practice: Creating Custom Formats Based on Single Values20mLevel 2 Practice: Creating Custom Formats Based on a Range of Values20mActivity 4.0410mActivity 4.0510mLevel 1 Practice: Creating a Custom Format from a Table20mLevel 2 Practice: Using Conditional Processing to Create a Format from a Table20mCreating and Using Custom Formats50m

Week5

Week 5

3 hours to complete

Combining Tables

3 hours to complete

14 videos (Total 28 min), 1 reading, 10 quizzes

14 videos

Overview17sConcatenating Tables with Matching Columns1mDemo: Concatenating Tables3mHandling Column Attributes45sWhat is a Merge?1mProcessing a One-to-One Merge2mProcessing a One-To-Many Merge1mDemo: Merging Tables3mMerging Tables with Nonmatching Rows2mIdentifying Matches and Nonmatches1mDemo: Merging Tables with Nonmatching Rows6mMerging Tables with Matching Column Names1mMerging Tables without a Common Column1mDATA Step Merge and PROC SQL Join38s

1 reading

Syntax Review10m

10 practice exercises

Activity 5.0110mLevel 1 Practice: Concatenating Like-Structured Tables20mLevel 2 Practice: Concatenating Unlike-Structured Tables20mQuestion 5.025mActivity 5.0310mQuestion 5.045mActivity 5.0510mLevel 1 Practice: Performing a One-to-Many Merge20mLevel 2 Practice: Writing Matches and Nonmatches to Separate Tables20mCombining Tables50m

Week6

Week 6

3 hours to complete

Processing Repetitive Code

3 hours to complete

11 videos (Total 25 min), 1 reading, 7 quizzes

11 videos

Overview13sProcessing Repetitive Code50sIterative DO Loops2mDemo: Executing an Iterative DO Loop2mOutput Inside and Outside the DO Loop2mDemo: Using Iterative DO Loops5mConditional DO Loops1mChecking the Condition1mDemo: Using Conditional DO Loops4mCombining Iterative and Conditional DO Loops1mDemo: Combining Iterative and Conditional DO Loops3m

1 reading

Syntax Review10m

7 practice exercises

Activity 6.0110mLevel 1 Practice: Using Nested Iterative DO Loops (DATA Step with No SET Statement)20mLevel 2 Practice: Using an Iterative DO Loop (DATA Step with a SET Statement)20mActivity 6.0210mLevel 1 Practice: Using a Conditional DO Loop20mLevel 2 Practice: Using an Iterative and Conditional DO Loop20mProcessing Repetitive Code50m

Week7

Week 7

3 hours to complete

Restructuring Tables

3 hours to complete

10 videos (Total 12 min), 1 reading, 9 quizzes

10 videos

Overview14sUnderstanding Table Structure46sRestructuring Data36sDemo: Creating a Narrow Table with the DATA Step2mCreating a Wide Table with the DATA Step44sThe Transpose Procedure24sTransposing Values within Groups48sDemo: Creating a Wide Table with PROC TRANSPOSE4mCreating a Narrow Table with PROC TRANSPOSE27sChanging Column Names59s

1 reading

Syntax Review10m

9 practice exercises

Question 7.015mActivity 7.0210mLevel 1 Practice: Restructuring a Table Using the DATA Step: Wide to Narrow20mLevel 2 Practice: Restructuring a Table Using the DATA Step: Narrow to Wide20mActivity 7.0310mActivity 7.0410mLevel 1 Practice: Restructuring a Table Using PROC TRANSPOSE: Wide to Narrow20mLevel 2 Practice: Restructuring a Table Using PROC TRANSPOSE: Narrow to Wide20mRestructuring Tables50m

Reviews

4.8

150 reviews

5 stars
85.56%
4 stars
12.60%
3 stars
1.60%
1 star
0.22%

TOP REVIEWS FROM DOING MORE WITH SAS PROGRAMMING

by SGNov 11, 2021

I've got it finally. The course brings lots of knowledge and skills. It would be quite helpful to analyze, obtain, output and transpose tables and reports efficiently.

by VSJul 15, 2020

I enjoyed this course. I learned many useful things for SAS programming. Particularly valuable techniques covered here are DO loops, RETAIN statements and merging tables.

by VMSep 9, 2021

Excellent course, with short videos that were well made and detailed excercises, demos and activities. I very much enjoyed this course and it's the first coursera course I've actually finished!

by RSAug 14, 2019

This course provided me with the know how needed to write SAS programs. I would definitely recommend this course for folks looking to get an insight on writing or understanding SAS codes.

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

Doing More with SAS Programming

About this Course