| Date: | Mon, 12 Mar 2007 10:42:48 -0600 |
|---|
| Reply-To: | Suhong Tong <sophidt@HOTMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Suhong Tong <sophidt@HOTMAIL.COM> |
|---|
| Subject: | Re: Any better way to transpose the data? |
|---|
|
| In-Reply-To: | <7367b4e20703120922t64df588xc80d22c1b79f2aa9@mail.gmail.com> |
|---|
| Content-Type: | text/plain; format=flowed |
|---|
Here is the simplified version of my data structure:
ID question response
1 q1 r1
1 q2 r3
...
1 q99 r5
2 q1 r3
2 q2 r2
want:
ID q1 q2 ....q99
1 r1 r3 r5
2 r3 r2 .......
I hope I explained clear, thank you for help.
Sophia
>From: "data _null_;" <datanull@gmail.com>
>To: "Sophia Tong" <sophiDT@hotmail.com>
>CC: SAS-L@listserv.uga.edu
>Subject: Re: Any better way to transpose the data?
>Date: Mon, 12 Mar 2007 12:22:34 -0400
>
>On 3/12/07, Sophia Tong <sophiDT@hotmail.com> wrote:
>>Dear SAS-L experts,
>>
>>I have a data with variables stored as values(about 100+ variables) under
>>one variable,
>I would think this IS the "best" data structure.
>
>>I need transpose them in order to organize the data.
>Give more details. One person's organization is another person's
>nightmare.
_________________________________________________________________
Find a local pizza place, movie theater, and more….then map the best route!
http://maps.live.com/?icid=hmtag1&FORM=MGAC01
| 
