- Welcome to the Course
- Practicing in the Course
- DATA Step Processing
- Processing a Data Set
- Demo: Reviewing DATA Step Syntax and Processing
- Home
- SAS Institute
- Courses
- Advanced SAS Programming Techniques
Advanced SAS Programming Techniques
Upgrade your data analytics skills by enrolling for the Advanced SAS Programming Techniques Course by Coursera.
Intermediate
Online
5 Weeks
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
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.
The highlights
- Online course
- Flexible deadlines
- Requires approximately 17 for completion
- Intermediate level course
- Certificate from Coursera
- Seven days of free trial
Program offerings
- Practice assignments
- Course discussion forum
- Videos
- Quizzes
- Assignments
- Learning videos
Course and certificate fees
Advanced SAS Programming Techniques Fee Details
Course | Fees in INR |
1 Month | Rs. 4,001 (plus GST) |
3 Months | Rs. 8,003 (plus GST) |
6 Months | Rs. 12,004 (plus GST) |
certificate availability
certificate providing authority
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
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
Who it is for
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.
The syllabus
Week 1: Course Overview, Review, and Data Setup
Videos
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
Week 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
Week 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
Week 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
Week 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
Practice Exercise
- 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
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
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.
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.
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.
Yes, the videos can be downloaded for offline viewing. The subtitles of the video can also be downloaded as a transcript file.
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.
No, hard-copy of the certificate is not provided. Coursera provides a PDF file of the certificate which can be printed by the participants.
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.
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.
Articles
Popular Articles
Latest Articles
Similar Courses
SAS Macro Language
SAS Institute via Coursera
Doing More with SAS Programming
SAS Institute via Coursera
Practical SAS Programming and Certification Review
SAS Institute via Coursera
Courses of your interest
Build AI Apps with ChatGPT Dall E and GPT 4
Scrimba via Coursera
Artificial Intelligence Ethics in Action
LearnQuest via Coursera
Artificial Creativity
Parsons School of Design, The Ne... via Coursera
Data Science on Microsoft Azure Using Python Progr...
CloudSwyft Global Systems, Inc via Futurelearn
Hashing in Java
Great Learning
Binary Trees
Great Learning
Fullstack Enterprise Mongo Express Vue And Node
Simpliv Learning
Visual Design for Web Designers UI Designers and D...
Simpliv Learning
Learning Algorithms in JavaScript from Scratch
Simpliv Learning
JavaScript Interview Preparation Practice Problems
Simpliv Learning
More Courses by SAS Institute
Statistics with SAS
SAS Institute via Coursera