SAS® 9.4 Cert Prep: Part 09 Summarizing Data
18mBeginner2020-01-07
Authors
SAS Institute
Business analytics software and services
Course details
Want to get ahead in a crowded job market? Get certified with SAS. This course is part of a series by the SAS Institute, designed to prepare you for the SAS 9.4 certification exam. Here you can explore techniques for summarizing data using the SAS DATA step. Instructor Stacey Syphus explains how to alter the behavior of the DATA step to create an accumulating column—also known as a running total—and process data in groups, so that you can perform an action when a group begins or ends.
Skills covered
SASStatisticsCert PrepData Science
Concepts
Introduction
- use new syntax to target endpoints in your data
Creating an Accumulating Column
- demo- creating an accumulating column
- retaining values in the pdv
- using the sum statement
Processing Data in Groups
- answering questions about groups
- processing sorted data in groups
- demo- identifying the first and last row in each group
- subsetting rows in the execution phase
- demo- creating an accumulating column within groups
- using multiple by columns