Date:         Tue, 15 May 2007 09:40:58 -0700
Reply-To:     sdlenter <sdlentert@AOL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sdlenter <sdlentert@AOL.COM>
Organization: http://groups.google.com
Subject:      Re: Summary of count
Comments: To: sas-l@uga.edu
In-Reply-To:  <BAY103-F137D871FF59583C5156A17B03D0@phx.gbl>
Content-Type: text/plain; charset="iso-8859-1"

On May 14, 10:45 pm, davidlcass...@MSN.COM (David L Cassell) wrote:
> sdlent...@AOL.COM wrote:
>
> >i have a sas dataset
> >Type   TotalCount
> >aaa   2
> >aaa   2
> >ddd   4
> >ddd   4
> >ddd   4
> >ddd   4
>
> >I need to create another dataset that would group the fields (type)
> >and will look like this  (without repeating)
> >aaa   2
> >ddd   4
>
> >I used this code to get "TotalCount"
> >PROC SQl;
> >Create Table new
> >Select  Type
> >count(Type)as TotalCount
> > >From   have
> >group by Type;
> >Quit;
>
> >that's how i got my table
> >Type   TotalCount
> >aaa   2
> >aaa   2
> >ddd   4
> >ddd   4
> >ddd   4
> >ddd   4
>
> >Thanks for help
>
> Wait, I don't understand.  Are you saying that the problem is that
> your current code gives you duplicate records, and you don't want
> to fix that code, but you want more code to resolve the errors
> with the current code?
>
> Perhaps you could write back to SAS-L and explain more about the
> problem, so someone here can help you more effectively...
>
> David
> --
> David L. Cassell
> mathematical statistician
> Design Pathways
> 3115 NW Norwood Pl.
> Corvallis OR 97330
>
> _________________________________________________________________
> More photos, more messages, more storage-get 2GB with Windows Live Hotmail.http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_m...- Hide quoted text -
>
> - Show quoted text -

that code didn't work, that's what I am saying and I would like to use
another code