SAS Tips and Tricks

Transposing your data

Transposing your data is a common problem in data manipulation. Very often data are stored in narrow structure for flexibility and storage purpose and have to be transposed in wide structure or vice versa. When Proc transpose can be used to your data, it's quite easy to convert your data. However, it becomes more difficult to do it with Data Step. This tips and tricks shows you how you can transpose your data thanks to Data Step.

Details

In this tips and tricks we will have a look to the differences between the narrow dataset structure and the wide dataset structure.
Then we will use the Proc transpose in order to convert the datasets from one structure to the other one. We will also discuss the limits of this technic.
Finally, we will do the same transformation exercise but in Data Step and highlight the differences in terms of flexibility and ease of use.

Prerequisites

You have some SAS experience and would like to transpose your data using Proc transpose or Data Step.

Quick Facts

  • Scheduled date: Course not yet scheduled
  • Duration :3 Hours
  • Fee :240 Euros (VAT Exclusive)
  • Language: French/English
  • Included: Coffees, tips and tricks material

Christophe Kabacinski

click here to get more information about this teacher.

Course Location

This course will be organized at : Lodge.co Boulevard Simon Bolivar 34 1000 Bruxelles


Go back to your selection