Explore

Advanced SAS Programming Techniques

Approx. 17 hours to complete

Save Course

Go to Course

Course Summary

Learn advanced SAS programming techniques, including advanced data manipulation and reporting, with this course from SAS.

Key Learning Points

Learn how to import and export data from a variety of sources.
Discover advanced data manipulation techniques.
Master the art of creating complex reports and graphs.
Develop your skills in optimizing SAS programs.
Get hands-on experience with real-world projects.

Learning Outcomes

Develop advanced SAS programming skills
Create complex reports and graphs
Optimize SAS programs for improved performance

Prerequisites or good to have knowledge before taking this course

Familiarity with SAS programming
Basic knowledge of statistics

Course Difficulty Level

Intermediate

Course Format

Online self-paced
Hands-on projects
Expert instruction

Similar Courses

SAS Programming for Data Science
Data Science Essentials

Related Education Paths

Notable People in This Field

SAS Programmer and Author
SAS Programmer and Author

Related Books

Description

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.

“By the end of this course, a learner will be able to…” ● Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW). ● Perform pattern matching using PRX functions. ● Process repetitive code, rotate data, and perform table lookups using arrays. ● Perform table lookups and sort data using hash and hash iterator objects. ● Create numeric templates using the FORMAT procedure. ● Create custom functions using the FCMP procedure.

Outline

Course Overview, Review, and Data Setup
Welcome to the Course
Practicing in the Course
DATA Step Processing
Processing a Data Set
Demo: Reviewing DATA Step Syntax and Processing
Learner Prerequisites
Using Forums and Getting Help
Access SAS Software for this Course
Set Up Data for This Course
Activity 1.01

Using Advanced Functions
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
Metacharacter Examples
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 Review

Defining and Processing Arrays
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
Array Advantages and Disadvantages
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 Review

Defining and Processing Hash Objects
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
Specifying the DATASET Argument
Using Multiple Method Statements
Hash Object Advantages and Disadvantages
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 Review

Using Utility Procedures
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
Advantages to Custom Functions and Call Routines
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 Review

Summary of User Reviews

Learn advanced SAS programming techniques with this course on Coursera. Expert instructors guide you through complex topics in a natural and easy-to-understand manner. Users praise the comprehensive curriculum and real-world examples.

Key Aspect Users Liked About This Course

The course provides a comprehensive curriculum and real-world examples.

Pros from User Reviews

Expert instructors provide guidance on complex topics
Curriculum covers a wide range of advanced SAS programming techniques
Real-world examples help to reinforce concepts
Flexible learning options allow users to study at their own pace

Cons from User Reviews

Some users find the course material challenging
The course may be too advanced for beginners
Limited interaction with instructors and peers
Course materials can be overwhelming

Recommended for you

Applied Data Visualization with R and ggplot2

Create useful, elaborate, and visually-appealing plots using this open source package You'll also get to grips with plotting trends,  correlations, and statistical summaries....

Save Course

Complete Linear Regression Analysis in Python

Linear Regression in Python| Simple Regression, Multiple Regression, Ridge Regression, Lasso and subset selection also You've found the right Linear Regression course!...

Save Course

Full Stack Web Developer Bootcamp

Learn HTML 5, CSS 3, Javascript, Bootstrap 4, Media Queries, PHP, OOP, MYSQL, Database. Become a Full Stack Developer!   This course offers the following programs...

Save Course