topic Re: transpose row data into multi columns in SAS Enterprise Guide

transpose row data into multi columns

deleted_user — Mon, 22 Dec 2008 19:31:34 GMT

Below are the contents of my dataset with 4 observations and 4 columns(a,b,c,d) with values x, y, z, x in each observation.
a b c d
1 x x x x
2 y y y y
3 z z z z
4 x x x x

Now, I need to transform this into below structure:

a1 b1 c1 d1 a2 b2 c2 d2 a3 b3 c3 d3 a4 b4 c4 d4
== == == == == == == == == == == == == == == ==
x x x x y y y y z z z z x x x x

In the other sense, all the row data needs to be transformed into columns (appending each column name with the observation a1, b1, a2, b2 etc...)

How I can achieve this, any easy way to accomplish this?

Re: transpose row data into multi columns

sbb — Mon, 22 Dec 2008 20:35:05 GMT

For future consideration, it is not necessary to post a question in more than one forum.

Scott

Re: transpose row data into multi columns

deleted_user — Mon, 22 Dec 2008 21:53:28 GMT

Are you using SAS DI or you want to do this using PROC ?
If you are doing SAS DI then use Process Library -> Data Transforms -> Transpose,

If you check the Contents Help you have Step-by-Step Procedure for how to Do this , It is simple & easy to follow so i am not going to re invent the wheel here!

Good Luck