Date:         Sat, 1 Sep 2007 04:48:45 -0400
Reply-To:     Jenny Holm <jennykbh@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jenny Holm <jennykbh@GMAIL.COM>
Subject:      Restructuring a data set

Hi,
I'm having major difficulties in resturcturing a data set from:

ID x1 x2 x3   x4 x5 x6... x21
1  1  2  3    16 17 18
2  4  5  6    19 20 21
3  7  8  9    22 23 24
4  10 11 12   25 26 27
5  13 14 15   28 29 30

to:

ID x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 x11 x12 x13 x14 x15
1  1  2  3  4  5  6  7  8  9  10  11  12  13  14  15
2  16 17 18 19 20 21 22 23 24 25  26  27  28  29  30
...
7

The variable names are irrelevant to me- I am trying to change the order of
the data. The closest I've come to any success is by using a sql outer
union-but then I end up with to many rows. I have to repeat this task for
>60 data sets, so I would appreciate any suggestions!

Thank you,
Jenny