Date:         Mon, 2 Nov 2009 19:10:38 -0800
Reply-To:     peter zeng <taifa.strong@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         peter zeng <taifa.strong@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: split data
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Nov 2, 5:30 pm, art...@NETSCAPE.NET (Arthur Tabachneck) wrote:
> Peter,
>
> I think you are only asking how you can create a new variable from the first
> three characters of an existing variable.  If so,
>
> complete_room=substr(room,1,3);
>
> HTH,
> Art
> -------
> On Mon, 2 Nov 2009 14:31:25 -0800, peter zeng <taifa.str...@GMAIL.COM>
> wrote:
>
>
>
> >Hey all,
> >I think my question is simple for you guys.
> >do you guys know how to split the data in proc report
> >how to group ABC and sum of ABC123A,B,C
> >I try to figure it out,but I do not know how to do it.
> >please give me a help
> >thanks
> >Pete
>
> >proc report=data;
>
> >  room        hours
> >ABC123A  1.2
> >ABC123B   2.3
> >ABC123C   3.4

Thank you all for explanation, Thank
you all for your time and help