Getting Started with SAS Programming (Coursera)

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.
Prerequisites:

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.

Course 1 of 3 in the SAS Programmer Professional Certificate

Syllabus

WEEK 1

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.

Essentials

In this module you learn how to use SAS programming tools and the fundamentals of SAS program structure and syntax.

WEEK 2

Accessing Data

In this module, you learn to identify the features of a SAS table, access data through SAS libraries, and import data into SAS.

WEEK 3

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.

WEEK 4

Preparing Data

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.

WEEK 5

Analyzing and Reporting on Data

In this module, we concentrate on summarizing data by using the SAS procedures that we touched on for data exploration. You also learn how to use titles, column labels, footnotes, and macro variables to enhance your reports and make them more meaningful.

WEEK 6

Exporting Results

In this module, you learn to export SAS tables and results to Excel, Microsoft Word, and PDF files.

Using SQL in SAS

In this module, you learn to use the SQL procedure to read and filter data. You also learn to create and join tables by using SQL.