| Date: | Mon, 14 May 2007 22:45:46 -0700 |
|---|
| Reply-To: | David L Cassell <davidlcassell@MSN.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | David L Cassell <davidlcassell@MSN.COM> |
|---|
| Subject: | Re: Summary of count |
|---|
| In-Reply-To: | <1179183220.406511.174910@w5g2000hsg.googlegroups.com> |
|---|
| Content-Type: | text/plain; format=flowed |
|---|
sdlentert@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_migration_HM_mini_2G_0507
| 
