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
0. Introduction
- 01 - Use new syntax to target endpoints in your data
1. Creating an Accumulating Column
- 02 - Demo - Creating an accumulating column
- 03 - Retaining values in the PDV
- 04 - Using the Sum statement
2. Processing Data in Groups
- 05 - Answering questions about groups
- 06 - Processing sorted data in groups
- 07 - Demo - Identifying the first and last row in each group
- 08 - Subsetting rows in the Execution phase
- 09 - Demo - Creating an accumulating column within groups
- 10 - Using multiple BY columns
Related courses
- SAS Essential Training: 2 Regression Analysis for Healthcare Research
- SAS Essential Training: 1 Descriptive Analysis for Healthcare Research
- Advanced SAS Programming for R Users, Part 2
- SAS Programming for R Users, Part 2
- SAS Programming for R Users, Part 1
- SAS® 9.4 Cert Prep: Part 10 Manipulating Data with Functions
- SAS® 9.4 Cert Prep: Part 08 Controlling Data Step Processing
- SAS® 9.4 Cert Prep: Part 14 Restructuring Tables