From the course: SAS® 9.4 Cert Prep: Part 14 Restructuring Tables

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Creating a narrow table with PROC TRANSPOSE

Creating a narrow table with PROC TRANSPOSE - SAS Tutorial

From the course: SAS® 9.4 Cert Prep: Part 14 Restructuring Tables

Start my 1-month free trial Buy for my team

Creating a narrow table with PROC TRANSPOSE

“

- [Instructor] Now suppose you're starting with a wide table where each storm has four separate columns for Wind1 through Wind4. You want to transpose the values of Wind1 through Wind4 for each unique combination of season, basin, and name. That creates four rows per storm where each row is one of the wind measures. You can convert a wide table to a narrow table by making minor adjustments to the PROC TRANSPOSE code.

Contents