SAS® 9.4 Cert Prep: Part 14 Restructuring Tables

Prepare to take the SAS 9.4 certification exam. Learn how to restructure tables with the DATA step and TRANSPOSE procedure.

Introduction

• Restructure your data

1. Restructuring Data with the DATA Step

• Understanding table structure
• Restructuring data
• Demo: Creating a narrow table with the DATA step
• Creating a wide table with the DATA step

2. Restructuring Data with the TRANSPOSE Procedure

• The TRANSPOSE procedure
• Transposing values within groups
• Demo: Creating a wide table with PROC TRANSPOSE
• Creating a narrow table with PROC TRANSPOSE
• Changing column names