Doing More with SAS Programming by SAS Institute via Coursera: Fee, Duration, How to Apply

Quick Facts

particular	details
Medium of instructions English	Mode of learning Self study	Mode of Delivery Video and Text Based

Course overview

Along with SAS, Coursera has created doing more with SAS programming for working professionals like SAS programmers and business analysts. This program would give in-depth knowledge about techniques of data manipulation using SAS procedures and DATA steps to transform, summarize, and access data. The course is based upon the concepts involved in the introduction of the SAS Programming course which states that should not be proposed to the users of SAS software at a beginner level.

Through this course, instructors would provide instruction to the participants on controlling the process of the DATA step, creating an accumulating column, and processing data in groups. The course would give a better understanding of SAS software and data used for practices and activities. The program would take the participants deeper into the DATA step and its knowledge would help in controlling and converting the DATA step output rows to new tables. After this, they will learn about processing data in groups which would help in executing action whether each group starts or finishes.

Course and certificate fees

Fee details for the Doing more with SAS programming are given below :

Head	Amount
1 Month	Rs. 4,115
3 Months	Rs. 8,230
6 Months	Rs. 12,345

certificate availability

Yes

certificate providing authority

Coursera

Who it is for

Data analyst Business analyst

Doing more with SAS programming by Coursera offers training to the following individuals -
SAS Programmer
Database administrator
Analytics Managers
Statistician
Quality AnalystBusiness Analyst
SAS Developer

Eligibility criteria

Prerequisites

Before applying for this course, the candidate should know how to write DATA step code to access data, and process data in groups.

Education

No specific educational background is required for applying for this course.

Certification Qualifying Details

Candidates will get a certificate once they complete the course. The e-certificate can be added to the accomplishments page. Candidates can print this certificate and add it to the LinkedIn profile.

What you will learn

Knowledge of data steps

After completing the course, the participants would be able to manipulate data using SAS procedures and the DATA step.

They will become capable of understanding and controlling the process of the DATA step and create custom formats.
Through syntax review, they would learn to rectify the default actions of the DATA step required to solve a problem.

The syllabus

Module 1: Course Overview and Data Setup

Videos

Welcome to the Course!
Practicing in This Course

Readings

Learner Prerequisites
Follow These Instructions to Set Up Data for This Course (REQUIRED)
Using Forums and Getting Help

Module 2: Controlling DATA Step Processing

Videos

Overview
DATA Step Review
DATA Step Processing
DATA Step Processing: Compilation
DATA Step Processing: Execution
Demo: DATA Step Processing in Action
Viewing Execution in the Log
Controlling DATA Step Processing
Implicit and Explicit Output
Sending Output to Multiple Tables
Demo: Directing Row Output
Controlling Column Output
Demo: Directing Column Output
Columns in the PDV

Readings

Syntax Review

Practice Exercise

Activity 1.01
Activity 1.02
Practice: Using PUTLOG Statements to Examine Execution Steps
Activity 1.03
Activity 1.04
Question 1.05
Level 1 Practice: Conditionally Creating Multiple Output Tables
Level 2 Practice: Conditionally Creating Columns and Output Tables
Controlling DATA Step Processing

Module 3: Summarizing Data

Videos

Overview
Demo: Creating an Accumulating Column
Retaining Values in the PDV
Using the Sum Statement
Answering Questions about Groups
Processing Sorted Data in Groups
Demo: Identifying the First and Last Row in Each Group
Subsetting Rows in the Execution Phase
Demo: Creating an Accumulating Column within Groups
Using Multiple BY Columns

Readings

Syntax Review

Practice exercises

Activity 2.01
Question 2.02
Level 1 Practice: Producing a Running Total
Level 2 Practice: Producing Multiple Totals
Activity 2.03
Activity 2.04
Activity 2.05
Question 2.06
Level 1 Practice: Generating an Accumulating Column within Groups
Level 2 Practice: Generating an Accumulating Column within Multiple Groups
Summarizing Data

Module 4: Manipulating Data with Functions

Videos

Overview
Review of Functions
Specifying Columns Lists
Using a CALL Routine to Modify Data
Using Numeric Functions
Demo: Using Numeric Functions
SAS Date, Datetime, and Time Values
Extracting Data from a Datetime Value
Calculating Date Intervals
Shifting Date Values
Demo: Shifting Date Values Based on an Interval
Useful Character Functions
Extracting Words from a String
Demo: Using Character Functions to Extract Words from a String
Searching for Character Strings
Replacing Character Strings
Handling Column Type
Converting Column Type
Converting Character Values to Numeric Values
Using a Generic Information to Read Dates
Converting the Type of an Existing Column
Converting Numeric Values to Character Values
Demo: Using the INPUT Function to Convert Column Types
Demo: Using the PUT Function to Convert Column Types

Readings

Using Numeric Functions to Change Precision
Removing Characters from a String
Identifying Character Positions
Building Character Strings
Syntax Review

Practice Exercise

Activity 3.01
Activity 3.02
Activity 3.03
Activity 3.04
Question 3.05
Level 1 Practice: Using the LARGEST and ROUND Functions
Level 2 Practice: Working with Date/Time Values
Activity 3.06
Activity 3.07
Activity 3.08
Activity 3.09
Level 1 Practice: Using the SCAN and PROPCASE Functions
Level 2 Practice: Searching for Character Strings
Activity 3.10
Activity 3.11
Question 3.12
Activity 3.13
Manipulating Data with Functions

Module 5: Creating and Using Custom Formats

Videos

Overview
Formatting Data Values
Creating and Applying a Custom Format
Using Ranges
Demo: Creating and Using Custom Formats
Reading a Table of Values for a Format
Demo: Creating Custom Formats from Tables
Storing Custom Formats

Readings

Syntax Review

Practice Exercises

Activity 4.01
Activity 4.02
Activity 4.03
Level 1 Practice: Creating Custom Formats Based on Single Values
Level 2 Practice: Creating Custom Formats Based on a Range of Values
Activity 4.04
Activity 4.05
Level 1 Practice: Creating a Custom Format from a Table
Level 2 Practice: Using Conditional Processing to Create a Format from a Table
Creating and Using Custom Formats

Module 6: Combining Tables

Videos

Overview
Concatenating Tables with Matching Columns
Demo: Concatenating Tables
Handling Column Attributes
What is the Merge?
Processing a One-to-One Merge
Processing a One-To-Many Merge
Demo: Merging Tables
Merging Tables with Nonmatching Rows
Identifying Matches and Nonmatches
Demo: Merging Tables with Nonmatching Rows
Merging Tables with Matching Column Names
Merging Tables without a Common Column
DATA Step Merge and PROC SQL Join

Readings

Syntax Review

Practice Exercises

Activity 5.01
Level 1 Practice: Concatenating Like-Structured Tables
Level 2 Practice: Concatenating Unlike-Structured Tables
Question 5.02
Activity 5.03
Question 5.04
Activity 5.05
Level 1 Practice: Performing a One-to-Many Merge
Level 2 Practice: Writing Matches and Nonmatches to Separate Tables
Combining Tables

Module 7: Processing Repetitive Code

Videos

Overview
Processing Repetitive Code
Iterative DO Loops
Demo: Executing an Iterative DO Loop
Output Inside and Outside the DO Loop
Demo: Using Iterative DO Loops
Conditional DO Loops
Checking the Condition
Demo: Using Conditional DO Loops
Combining Iterative and Conditional DO Loops
Demo: Combining Iterative and Conditional DO Loops

Reading

Syntax Review

Practice Exercises

Activity 6.01
Level 1 Practice: Using Nested Iterative DO Loops (DATA Step with No SET Statement)
Level 2 Practice: Using an Iterative DO Loop (DATA Step with a SET Statement)
Activity 6.02
Level 1 Practice: Using a Conditional DO Loop
Level 2 Practice: Using an Iterative and Conditional DO Loop
Processing Repetitive Code

Module 8: Restructuring Tables

Videos

Overview
Understanding Table Structure
Restructuring Data
Demo: Creating a Narrow Table with the DATA Step
Creating a Wide Table with the DATA Step
The Transpose Procedure
Transposing Values within Groups
Demo: Creating a Wide Table with PROC TRANSPOSE
Creating a Narrow Table with PROC TRANSPOSE
Changing Column Names

Reading

Syntax Review

Practice Exercise

Question 7.0
Activity 7.02
Level 1 Practice: Restructuring a Table Using the DATA Step: Wide to Narrow
Level 2 Practice: Restructuring a Table Using the DATA Step: Narrow to Wide
Activity 7.03
Activity 7.04
Level 1 Practice: Restructuring a Table Using PROC TRANSPOSE: Wide to Narrow
Level 2 Practice: Restructuring a Table Using PROC TRANSPOSE: Narrow to Wide
Restructuring Tables

Admission details

Here are the simple steps that need to be followed by the students for applying for Doing more with SAS Programming:

Step 1: Visit the course page.

Step 2: Click on “Enroll for free” to fill in the necessary details

Step 3: After 7 days of trial, either the candidate can cancel the admission of the candidate need to pay a certain amount to continue access to the course

Step 4: Share your billing details and choose a payment method.

Step 5: Complete the transaction.

Scholarship Details

Doing more with SAS Programming does not offer any scholarship students can get financial aid by clicking on the link provided. The candidates need to fill in the application. Once the application is approved, they will be notified by Coursera.

How it helps

Coursera is offering the golden opportunity to the participants to learn in-depth about SAS that authorizes and motivates consumers across the globe to modify data into intelligence. SAS is considered to be an analytics powerhouse of an organization that helps in seeking immediate worth from the data. This programme is not suggested for beginners as it is appropriate for professionals at the intermediate level. On the completion of the course, it would take the participants from intermediate level to expert level. The participants would learn in-depth about DATA step processes and they will be trained to execute the knowledge in creating output rows to new tables.

The course would train the candidate to test and analyze the algorithm of the database. While summarizing the data, the candidates would learn to adjust the default actions that occur in the DATA step while finding a solution to a problem. The instructors would train the participants in creating and utilizing custom formats to boost the means of data in displaying data in a form of a report or a table.

According to the previous study, after completing the course 33% of participants earned a tangible career advantage from the course whereas 50% of the participants either received a promotion or an increase in the payroll.

Instructors

Ms Stacey Syphus
Senior Manager
SAS Institute

M.S

FAQs

Will, I get university credit after completing the course?

Unfortunately, Coursera doesn’t provide the advantage of university credit. However, some universities may accept the certificate for credit.

How to apply for a refund?

After registering for this course, the candidate gets a 7-day free trial and during this time they can unsubscribe without any penalty. But after 7-days, they can cancel the subscription but no refunds would be given.

When can I have access to the study materials?

Accessing the study material depends on the enrolment option chosen. For audit mode, students have access to the study materials for free; however, to get the certificate and assignments, students need to pay a certain fee.

What if “Audit Mode” is unavailable?

In such a scenario, candidates can opt for Free Trial or Financial Aid. In addition, they can also choose the “Full Course, No certificate” option. This implies candidates will get the study material but cannot purchase a Certificate.

What happens on subscribing the certificate?

After enrollment, the candidate will get access to all the courses and after completion of the work, the candidate would earn the certificate. After completing the course, students get an e-certificate that will be attached to his/her accomplishment page.