https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/plz-help-in-transposing/m-p/44456#M1324 my raw data is like this<BR /> id ab bb cb db eb a1 b1 c1 d1 e1 a2 b2 c2 d2 e2 a3 b3 c3 d3 e3<BR /> 1 11 23 43 23 43 12 34 54 23 43 11 23 45 67 65 11 23 45 67 32<BR /> 2 43 54 76 87 45 67 87 54 67 89 76 54 34 67 89 09 76 45 34 56<BR /> <BR /> I have to make it like this<BR /> base 1wk 2wk 3wk<BR /> a 11 12 11 11<BR /> b 23 34 23 23<BR /> c 43 54 45 45<BR /> d 23 23 67 67<BR /> e 43 43 65 32<BR /> <BR /> <BR /> <BR /> 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<BR /> <BR /> Thanks in advance Mon, 15 Jun 2009 07:22:03 GMT Parashar 2009-06-15T07:22:03Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/plz-help-in-transposing/m-p/44456#M1324 my raw data is like this<BR /> id ab bb cb db eb a1 b1 c1 d1 e1 a2 b2 c2 d2 e2 a3 b3 c3 d3 e3<BR /> 1 11 23 43 23 43 12 34 54 23 43 11 23 45 67 65 11 23 45 67 32<BR /> 2 43 54 76 87 45 67 87 54 67 89 76 54 34 67 89 09 76 45 34 56<BR /> <BR /> I have to make it like this<BR /> base 1wk 2wk 3wk<BR /> a 11 12 11 11<BR /> b 23 34 23 23<BR /> c 43 54 45 45<BR /> d 23 23 67 67<BR /> e 43 43 65 32<BR /> <BR /> <BR /> <BR /> 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<BR /> <BR /> Thanks in advance Mon, 15 Jun 2009 07:22:03 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/plz-help-in-transposing/m-p/44456#M1324 Parashar 2009-06-15T07:22:03Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/plz-help-in-transposing/m-p/44457#M1325 It is not necessary to post a particilar query in multiple SAS discussion forums.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Mon, 15 Jun 2009 11:18:15 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/plz-help-in-transposing/m-p/44457#M1325 sbb 2009-06-15T11:18:15Z