Understand and use the fundamentals of the SAS programming languageAccess different types of data (SAS, Excel, or text),
then explore and prepare the data Analyze and report on data and export results to common
formats (HTML, PDF, Excel) Apply SAS programming principles in practical examples
When you complete the SAS® Base Programming courses, you will have demonstrated skills in manipulating and transforming data,
combining SAS data sets, creating basic detail and summary reports using SAS
procedures and identifying and correcting data, syntax and programming logic
errors. These skills prepare you for the SAS® Base Programmer certification exam.
Getting Started with SAS Programming
This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses.By the end of this course, you will know how to use SAS Studio to write and submit SAS programs that access SAS, Microsoft Excel, and text data. You will know how to explore and validate data, prepare data by subsetting rows and computing new columns, analyze and report on data, export data and results to other formats, use SQL in SAS to query and join tables.
Learners should have experience using computer software. Specifically, you should be able to understand file structures and system commands on your operating systems and access data files on your operating systems. No prior SAS experience is needed.
Doing More with SAS Programming
This course is for business analysts and SAS programmers who want to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the Getting Started with SAS Programming course and is not recommended for beginning SAS software users.In this course you learn how to understand and control DATA step processing, create an accumulating column and process data in groups, manipulate data with functions, convert column type, create custom formats, concatenate and merge tables, process repetitive code, and restructure tables. This course addresses Base SAS software.
Before attending this course, you should be able to write DATA step code to access data, subset rows and columns, compute new columns, and process data conditionally. You should also be able to sort tables using the SORT procedure and
apply SAS formats.
Practical SAS Programming and Certification Review
In this course you have the opportunity to use the skills you acquired in the two SAS programming courses to solve realistic problems. This course is also designed to give you a thorough review of SAS programming concepts so you are prepared to take the SAS Certified Specialist: Base Programming Using SAS 9.4 Exam.
In the last course of this specialization, you complete projects that demonstrate your knowledge of SAS programming. In the
first project, you write programs for each stage of the SAS programming
process to analyze passenger claims at United States airports. In the second
project, you use your knowledge of the data preparation stage to write
programs that restructure world tourism data.