SAS® 9.4 Cert Prep: Part 14 Restructuring Tables
12mBeginner2020-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 learn how to alter the layout of tables by restructuring data. Instructor Stacey Syphus explains how to restructure data with the DATA step and TRANSPOSE procedure and convert tables to both narrow and wide formats.
Skills covered
SASData Resource ManagementDatabase ManagementCert Prep
Concepts
Introduction
- restructure your data
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
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