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

About this Course
Instructor
Offered by

SAS
Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.
Syllabus - What you will learn from this course
Course Overview, Review, and Data Setup
In this module, you'll set up software and data for this course. Then you'll review the concepts of SAS DATA step processing and how to process data sets.
Using Advanced Functions
In this module, you'll use advanced functions to compare data between multiple rows in a SAS table, find and count substrings within a column, and clean and standardize data.
Defining and Processing Arrays
In this module, you'll learn how to use arrays to simplify your code. You'll use arrays to process repetitive code, rotate data, and perform table lookups.
Defining and Processing Hash Objects
In this module, you'll learn how to declare a hash object, instantiate or create an instance of the object, and initialize its lookup keys and data. You'll use the hash object to store and retrieve data, create an output table from the data in the hash object, and create a hash iterator object to process the data in a particular order.
Reviews
TOP REVIEWS FROM ADVANCED SAS PROGRAMMING TECHNIQUES
Passed SAS adv exam after taking this course. It's very useful.
About the SAS Advanced Programmer Professional Certificate
When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques and procedures to manipulate data. These skills prepare you for the SAS Advanced Programming Professional certification exam.

Frequently Asked Questions
Can I preview a course before enrolling?
What will I get when I enroll?
When will I receive my Course Certificate?
Why can’t I audit this course?
Will I earn university credit for completing the Course?
More questions? Visit the Learner Help Center.