Date:         Thu, 22 Mar 2012 16:51:43 -0500
Reply-To:     Charlie Huang <charlie.chao.huang@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Charlie Huang <charlie.chao.huang@GMAIL.COM>
Subject:      Re: Reshape data
Comments: To: "Schmid, Dennis (CDC/OSELS/SEPDPO) (CTR)" <wfu4@cdc.gov>
In-Reply-To:  <E9AED27F4BE8564F9A38F0A7899BDCCA01EF1658@EMBX-CLFT2.cdc.gov>
Content-Type: text/plain; charset=ISO-8859-1

Hi Dennis,

Yes -- it is exactly what I need. Thanks,

Charlie

On Thu, Mar 22, 2012 at 3:27 PM, Schmid, Dennis (CDC/OSELS/SEPDPO) (CTR) <
wfu4@cdc.gov> wrote:

> Charlie,
>
> I made one assumption about your name variable in my input statement.
>
>                                         The SAS System       16:15
> Thursday, March 22, 2012   7
>
>                           Obs     Name      Age    Height    Weight
>
>                            1     Alfred      14     69.0      112.5
>                            2     Alice        13      56.5        84.0
>                            3     Barbara  13      65.3        98.0
>                            4     Carol        14     62.8      102.5
>                            5     Henry      14     63.5      102.5
>
> data inpdat;
>  input @ 'NAME' Name $10. @ 'Age' Age  @ 'Height' Height  @ 'Weight'
> Weight ;
>  cards;
> NAME Alfred
> Age 14
> Height 69
> Weight 112.5
> NAME Alice
> Age 13
> Height 56.5
> Weight 84
> NAME Barbara
> Age 13
> Height 65.3
> Weight 98
> NAME Carol
> Age 14
> Height 62.8
> Weight 102.5
> NAME Henry
> Age 14
> Height 63.5
> Weight 102.5
> ;
> run; proc print;run;
>
>
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Charlie Huang
> Sent: Thursday, March 22, 2012 3:53 PM
> To: SAS-L@LISTSERV.UGA.EDU
>  Subject: Reshape data
>
> Hi SASLers,
>
> I have a question regarding data reshaping like below. I wonder if there
> is any good method to do it. Thanks a lot.
>
> I have:
>
> NAME Alfred
> Age 14
> Height 69
> Weight 112.5
> NAME Alice
> Age 13
> Height 56.5
> Weight 84
> NAME Barbara
> Age 13
> Height 65.3
> Weight 98
> NAME Carol
> Age 14
> Height 62.8
> Weight 102.5
> NAME Henry
> Age 14
> Height 63.5
> Weight 102.5
>
> I want:
>
> Name Age Height Weight
> Alfred 14 69 112.5
> Alice 13 56.5 84
> Barbara 13 65.3 98
> Carol 14 62.8 102.5
> Henry 14 63.5 102.5
>
> --
> Best regards,
> Charlie Huang
>



--
Best regards,
Charlie Huang