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.
Overview
Skills You'll Learn
Data Presentation, Data Analysis, Data Manipulation, Data Processing, SAS (Software), Data Transformation, Consolidation
Reviews
4.8 (939 ratings)
- 5 stars85.72%
- 4 stars12.46%
- 3 stars1.59%
- 1 star0.21%
VM
Sep 10, 2021
E鈥媥cellent course, with short videos that were well made and detailed excercises, demos and activities. I very much enjoyed this course and it's the first coursera course I've actually finished!
RS
Aug 15, 2019
This course provided me with the know how needed to write SAS programs. I would definitely recommend this course for folks looking to get an insight on writing or understanding SAS codes.
From the lesson
Combining Tables
In this module, we take a comprehensive look at combining tables by using the DATA step. You learn to concatenate tables, merge tables, and identify matching and nonmatching rows.
Taught By
Stacey Syphus
Director