SAS® 9.4 Cert Prep: Part 09 Summarizing Data

Prepare to take the SAS 9.4 certification exam. Learn techniques for summarizing data using the SAS DATA step.

Introduction

• Use new syntax to target endpoints in your data

1. Creating an Accumulating Column

• Demo: Creating an accumulating column
• Retaining values in the PDV
• Using the Sum statement

2. 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