plz help in transposing

Reply
Occasional Contributor
Posts: 5

plz help in transposing

my raw data is like this
id ab bb cb db eb a1 b1 c1 d1 e1 a2 b2 c2 d2 e2 a3 b3 c3 d3 e3
1 11 23 43 23 43 12 34 54 23 43 11 23 45 67 65 11 23 45 67 32
2 43 54 76 87 45 67 87 54 67 89 76 54 34 67 89 09 76 45 34 56

I have to make it like this
base 1wk 2wk 3wk
a 11 12 11 11
b 23 34 23 23
c 43 54 45 45
d 23 23 67 67
e 43 43 65 32



Please Help me with this and guid me how to transpose that using proc transpose or array or anything else pls give me coding for that also

Thanks in advance
Super Contributor
Super Contributor
Posts: 3,174

Re: plz help in transposing

It is not necessary to post a particilar query in multiple SAS discussion forums.

Scott Barry
SBBWorks, Inc.
Post a Question
Discussion Stats
  • 1 reply
  • 240 views
  • 0 likes
  • 2 in conversation