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.
Related Topics for further study
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
IntermediateCourse 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.
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
Michele Ensor
4.9 Raiting
Build Undetectable Malware Using C Language: Ethical Hacking
- 4.5
-
![]()
![]()
![]()
![]()
![]()
In This Advance Ethical Hacking Course You Will Learn How To Create Your Own Penetration Testing Tool With C Programming ...
Convolutional Neural Networks in Python: CNN Computer Vision
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Python for Computer Vision & Image Recognition - Deep Learning Convolutional Neural Network (CNN) - Keras & TensorFlow 2 You've found the right Convolutional Neural Networks course!...
Apache Spark With Examples for Big Data Analytics
- 2.5
-
![]()
![]()
![]()
![]()
![]()
In-depth course to master Spark SQL & Spark Streaming using Scala for Big Data (with lots real-world examples) This course is divided into 9 modules...
Customising your models with TensorFlow 2
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Welcome to this course on Customising your models with TensorFlow 2! You will also expand your knowledge of the TensorFlow APIs to include sequence models....
