Advanced SAS Programming Techniques 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	Learning efforts 5 Hours Per Week

Course overview

Coursera provides online courses designed by instructors from companies and universities. These courses give access to on-demand video lectures, quizzes, community forums, projects and homework exercises to amplify the learning experience of the participants.

Advanced SAS programming techniques course by Coursera has been designed for learners who wish to develop or improve their data analytics skills. The course aims to provide the participants with a deep dive into SAS programming. SAS enables the user to analyze, transform and derive value from the given data. It will train the participants in SAS programming using SAS 9, using the SAS macro facility to write, design, debug dynamic macro programmes, rotate data, process repetitive code, and perform table lookups using arrays and using PRX functions for pattern matching. Participants will learn the use of additional functions such as LAG, FINDC for data analysis and manipulation.

After the completion of the course, the participants will have developed a detailed perspective on SAS programming and the skills to use advanced DATA step techniques and procedures for manipulating the data. This course will prepare the participants for the SAS Advanced Programming Professional certification exam.

Course and certificate fees

Advanced SAS Programming Techniques Fee Details

Course	Fees in INR
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 Data scientist Data engineer

Eligibility criteria

Certification Qualifying Details

The participants must complete the course and meet the required graded assignments in order to get a course completion certificate for the Advanced SAS Programming Techniques Course by Coursera.

What you will learn

Programming skills

After completion of the Advanced SAS programming techniques course by Coursera participants will have knowledge of the following:

The core concepts of SAS programming.
Understanding concepts of DATA step processing
Develop an understanding of processing data sets
Evaluating data between multiple rows in the SAS table using advanced functions
Learning usage of arrays to simplify codes
Expertise in processing hash objects

The syllabus

Module 1: Course Overview, Review, and Data Setup

Videos

Welcome to the Course
Practicing in the Course
DATA Step Processing
Processing a Data Set
Demo: Reviewing DATA Step Syntax and Processing

Reading

Learner Prerequisites
Using Forums and Getting Help
Access SAS Software for this Course
Set Up Data for This Course

Practice Exercises

Activity 1.01

Module 2: Using Advanced Functions

Videos

Overview
Using Functions in SAS
Using the LAG Function
Demo: Retrieving Previous Values with the LAG Function
Calculating a Moving Average
Best Practice for Calculating a Moving Average
Using COUNT Functions
Using FIND Functions
Demo: Counting and Finding Words with Character Functions
What are Perl Regular Expressions?
What are Metacharacters?
PRXPARSE and PRXMATCH Functions
Demo: Validating Data with the PRXMATCH Function
PRXCHANGE Function
Capture Buffers
Demo: Standardizing Data with the PRXCHANGE Function

Readings

Metacharacter Examples

Practice Exercise

Activity 2.01
Activity 2.02
Activity 2.03
Activity 2.04
Practice Level 1: Using the LAG Function
Practice Level 2: Using the COUNT and FINDW Functions
Question 2.05
Activity 2.06
Activity 2.07
Practice Level 1: Using the PRXMATCH and PRXCHANGE Functions
Practice Level 2: Using the PRXCHANGE Function with Capture Buffers
Using Advanced Functions

Module 3: Defining and Processing Arrays

Videos

Overview
Processing Repetitive Code
Using an Array
Referencing an Array in a DO Loop
Unknown Number of Array Elements
Creating Numeric Columns with an Array
Specifying Lower and Upper Bounds
Demo: Processing One-Dimensional Arrays: Part 1
Rotating Data
Specifying Initial Values for Array Elements
Creating Character Columns with an Array
Demo: Processing One-Dimensional Arrays: Part 2
Two-Dimensional Arrays
Performing a Table Lookup
Demo: Processing Two-Dimensional Arrays: Part 1
Specifying Initial Values for Two-Dimensional Array Elements
Loading a Two-Dimensional Array from a Table
Demo: Processing Two-Dimensional Arrays: Part 2

Readings

Array Advantages and Disadvantages

Practice Exercise

Activity 3.01
Activity 3.02
Activity 3.03
Question 3.04
Practice Level 1: Using One-Dimensional Arrays on Numeric Data
Practice Level 2: Using One-Dimensional Arrays on Character Data
Question 3.05
Activity 3.06
Practice Level 1: Using a Two-Dimensional Array Based on Initial Values
Practice Level 2: Using a Two-Dimensional Array Based on Loading a Table
Defining and Processing Arrays

Module 4: Defining and Processing Hash Objects

Videos

Overview
Performing a Table Lookup: Example 1
What is a Hash Object?
Hash Object Process: Example 1
Declaring a Hash Object
Using Hash Object Methods
Demo: Declaring and Defining a Hash Object
Performing a Table Lookup: Example 2
FIND Method
KEY Arguments
Demo: Performing a Table Lookup with the FIND Method
Adding Data to a Hash Object
Saving a Hash Object
Demo: Creating a Table with the ADD and OUTPUT Methods
Unique and Duplicate Key Components
What is a Hash Iterator Object?
Creating the Hash Object and Hash Iterator Object
Hash Iterator Object Methods
Demo: Reading Data in Forward and Reverse Direction

Readings

Specifying the DATASET Argument
Using Multiple Method Statements
Hash Object Advantages and Disadvantages

Practice Exercise

Activity 4.01
Activity 4.02
Practice Level 1: Performing a Table Lookup Using One Key
Practice Level 2: Performing a Table Lookup Using Three Keys
Activity 4.03
Practice Level 1: Creating a Sorted Table from a Hash Object
Practice Level 2: Eliminating a PROC SORT step by Creating a Sorted Table from a Hash Object
Practice Level 1: Reading Data in Forward and Reverse Direction
Practice Level 2: Reading Data in Forward and Reverse Directions
Defining and Processing Hash Objects

Module 5: Using Utility Procedures

Videos

Overview
Creating Custom Formats
Custom Date and Datetime Formats
Demo: Specifying a Template for Datetime Values
Custom Numeric Formats
Custom Large Number Format
Demo: Specifying a Template for Large Numbers
Creating and Using a Custom Function
Demo: Creating Functions Containing One Argument
Passing and Returning Values
Demo: Creating Functions Containing Multiple Arguments
Creating a Custom Call Routine

Readings

Advantages to Custom Functions and Call Routines

Assignments

Question 5.01
Activity 5.02
Question 5.03
Practice Level 1: Specifying a Template Based on Date Directives
Practice Level 2: Specifying a Template Based on Digit Selectors
Activity 5.04
Practice Level 1: Creating a Custom Function That Returns a Numeric Value
Practice Level 2: Creating a Custom Function That Returns a Character Value
Using Utility Procedures

Admission details

Filling the form

Candidates who wish to enroll for the Advanced SAS Programming Techniques Course by Coursera have to follow these steps:

Step 1: Visit the Course Url.

Step 2: Select the enroll option.

Step 3: As soon as you click on the enrol option, you will be given the option of starting your 7 days free trial.

Step 4: After selecting the free trial option, you have to fill in the required payment details.

Step 5: After the end of the 7days free trial, participants will be charged for the course monthly.

Scholarship Details

Financial aid is provided by Coursera to candidates who cannot afford the fees of the course. To apply for financial aid, the participants have to fill the application that includes information about their educational background, career goals, and financial circumstances. After the application has been filled, it will be reviewed and an email will be sent to the applicant informing whether their application has been accepted or denied. Applicants have to commit to abiding by the Honor Code and our Code of Conduct.

How it helps

The Advanced Sas Programming Techniques Course By Coursera intends to provide a platform to candidates who wish to enhance their data analytics skills. SAS provides various analytics solutions and helps gain insight into the analysis of the given data. It is an online course with projects and assignments which will help the participants implement their learning and sharpen their skills in processing and comparing data in the SAS environment. The assignments will be graded to enable the participants to review their learning. The course will give the participants industry-required experience in SAS programming. After the completion of the course, the participants will have developed the required skills for using the advanced techniques and procedures to manipulate data, perform table lookups, creating numeric templates using the FORMAT procedure, sort data using hash and other valuable skills.

Instructors

Ms Michele Ensor
Instructor
SAS Institute

FAQs

Which facilities will be available during the course?

Participants will be given access to all videos, reading materials and the course discussion forum. They can work on the practice assessments, and complete the required graded assignments.

Who are community mentors?

Community mentors are those who help the learners work upon the courses they have already completed. They answer questions in the discussion forums, give feedback to Coursera staff and initiate discussions in the forum.

Who can become a community mentor?

Coursera sends email invitations to those learners who they think could become mentors for a particular course. The selected candidates are given short training by Coursera before they are enrolled as a mentor.

Can the videos be downloaded?

Yes, the videos can be downloaded for offline viewing. The subtitles of the video can also be downloaded as a transcript file.

How will I get the payment receipt?

After the payment, an email will be sent to the participant confirming the payment. The email shall include all the payment details. Coursera does not provide a hard copy of the payment receipt.

Does Coursera provide a hard-copy of the certificates?

No, hard-copy of the certificate is not provided. Coursera provides a PDF file of the certificate which can be printed by the participants.

How can verification problems be solved?

If the participants are not able to upload their photo, change, or update their ID verification during the verification process, they can try again later by using another device or troubleshooting the issue.

What is Coursera Plus?

In Coursera plus, the participants have to pay an annual subscription to gain access to the majority of the courses on Coursera. In Coursera plus there is no limit on the number of courses participants can enroll in or the course certificates participants can earn.