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.

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.

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