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.
What you will learn
Course Overview and Data Setup
In this module you learn about the course and you set up the data you need to do the practices in the course.
In this module you learn how to use SAS programming tools and the fundamentals of SAS program structure and syntax.
In this module, you learn to identify the features of a SAS table, access data through SAS libraries, and import data into SAS.
Exploring and Validating Data
In this module, you learn to use SAS procedures that provide insights about your data. You also learn to subset data so you can focus on particular segments, format data so you can easily understand it, and sort data to identify and resolve duplicate values.
In this module, you learn how to do some common data manipulations, such as filtering rows and columns, computing new columns, and performing conditional processing.