LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 2007, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page