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 2009, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 22 May 2009 11:10:39 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Summarizing data- need assistance
Comments: To: mtdinesh@GMAIL.COM

Dinesh,

I'm sure there is better way than the following, but I think it will do what you want:

proc transpose data=have out=want; id slno; run;

data want (keep=total clusters); set want (rename=(_name_=name)); all=cat(of _:); all=tranwrd(all,'.',' '); total=countc(all,'1234'); clusters=length(trim(left(compbl(all)))) -length(compress(left(all)))+1; run;

Art -------- On Fri, 22 May 2009 06:41:22 -0700, Dinesh <mtdinesh@GMAIL.COM> wrote:

>hello friends > >I am a fresher in SAS > >I am facing a problem > >I have a data set like this... > >slno 1d1 1d2 1d3 1d4 >1 . . . . >2 . . 3 . >3 1 . 3 . >4 1 . 3 . >5 1 2 3 . >6 1 2 3 . >7 . 2 3 . >8 . 2 3 . >9 . 2 3 4 >10 . . . 4 >11 1 . . 4 >12 1 . . 4 >13 1 . . 4 >14 1 . . 4 >15 1 2 . 4 >16 . 2 . 4 >17 . 2 . 4 >18 . 2 . 4 >19 . 2 3 4 >20 . 2 3 . >21 1 . 3 . >22 1 . 3 . >23 1 . 3 . >24 1 . 3 . > >I want to summarize this data set in such a way that i have to count >the number of clusters in each column, and also the total number of >elements in each column. The number of elements in each cluster will >be different > >The output I need is > > 1d1 1d2 1d3 1d4 >total 13 11 14 11 >clusters 3 2 2 1 > >Please provide some ideas to solve this. > >thanks in advance > >Dinesh


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