Date:         Thu, 7 Sep 2000 19:02:26 GMT
Reply-To:     Toni Zhang <thesis8@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Toni Zhang <thesis8@HOTMAIL.COM>
Subject:      transpose only four variables each time
Content-Type: text/plain; format=flowed

I have to reshape a data file by PROC TRANSPOSE. However, I need to
transpose four varialbes at once and do it for 14 times because the data
looks like

ID q301a q301b q301c q301d q302a q302b q302c q302d..q314a q314b..q314d
1
2
3
...

q30a-q301d stand for each individual's response for question 301 4 different
stores. So as q302a-q302d,...and q314a-q314d.

I need to transpose q301a-q301d, q302a-q302d, ...and q314a-q314d by ID, and
finally have a data that each person (ID) has 4 records. The data will look
like this:

=============================
id store q301 q302 q303 q304 q305 q306....q314
1  1
1  2
1  3
1  4
2  1
2  2
2  3
2  4
3 ...
================================

Instead of doing only 4 variables each time for 14 times, can I do it all at
once with NICER SAS code? Please help. Many thanX.

Tonnie.


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.