This course, Doing More with SAS Programming, is designed for business analysts and SAS programmers seeking to enhance their skills in data manipulation using SAS software. The comprehensive training covers advanced techniques for accessing, transforming, and summarizing data using the SAS DATA step and various procedures.
Throughout the course, participants will delve into the intricacies of controlling DATA step processing, summarizing data, manipulating data with functions, creating and using custom formats, combining tables, processing repetitive code, and restructuring tables. These modules build upon the foundational concepts from the Getting Started with SAS Programming course, making it ideal for experienced SAS software users.
By the end of the training, learners will have honed their abilities to write DATA step code, manipulate data with advanced functions, create custom formats, and effectively combine and restructure tables using SAS software.
Certificate Available ✔
Get Started / More Info
The Doing More with SAS Programming course comprises eight modules that cover advanced data manipulation techniques using SAS. Participants will gain in-depth knowledge and practical skills to effectively manipulate, summarize, and restructure data using SAS software.
Welcome to the Course!
Practicing in This Course
Learner Prerequisites
Using Forums and Getting Help
Access SAS Software and Set Up Practice Files (REQUIRED)
This module provides an overview of controlling DATA step processing, including compilation and execution. Participants will learn to manipulate row and column output, and practice using PUTLOG statements to examine execution steps.
This module focuses on summarizing data and creating accumulating columns. Participants will learn to process sorted data in groups, identify the first and last rows in each group, and generate running totals within groups.
Participants will explore manipulating data with functions, including numeric and character functions, and converting column types. They will practice using functions to change precision, remove characters from strings, and build character strings.
This module covers creating and using custom formats, including formatting data values, applying custom formats, and using ranges. Participants will also practice creating custom formats based on single values and a range of values.
Participants will learn to concatenate tables with matching columns and process one-to-one and one-to-many merges. They will also practice merging tables with nonmatching rows and learn about the DATA Step Merge and PROC SQL Join.
This module focuses on processing repetitive code, including iterative and conditional DO loops. Participants will practice using nested iterative DO loops and conditional DO loops, as well as combining iterative and conditional DO loops.
Participants will delve into restructuring tables, creating narrow and wide tables with the DATA Step, and using the Transpose Procedure. They will practice restructuring tables using PROC TRANSPOSE for wide to narrow and narrow to wide transformations.
Expressway to Data Science: R Programming and Tidyverse is a comprehensive specialization that teaches R programming and tidyverse for data science, preparing learners...
Artificial Intelligence Privacy and Convenience is a comprehensive course exploring the ethical considerations and practical methods for protecting user privacy...
NoSQL Systems is a comprehensive course covering the key aspects of NoSQL databases, enabling learners to understand and implement various NoSQL technologies to...
In this project-based course, you will learn to visualize UK accidents using Plotly Express, gaining insights into road accident trends, casualty rates, and accident...