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 (November 2006, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 28 Nov 2006 10:00:09 -0500
Reply-To:   Peter Crawford <peter.crawford@BLUEYONDER.CO.UK>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Peter Crawford <peter.crawford@BLUEYONDER.CO.UK>
Subject:   Re: Proc means problem

Mark

can you provide code and a data sample which demonstrate the problem is reproducable ?

Peter

On Tue, 28 Nov 2006 06:52:15 -0800, stulkem <mark.a.stulken@GTSERVICING.COM> wrote:

>The variable acctno is the account number. The macro looks at variables >that have conditions such as X>1 , X=1, X<1 and so on. > >Does anyone know how Proc Means can create the output in question? The >data is valid, and I've formatted the score, but proc means reports the >same buckets over and over again and appears to be in an infinite loop. >I have to manually stop my process overwise it keeps running.......Any >ideas why the data would be reported like this???? > >Thanks for the help! >Mark > > > > >Jake Bee wrote: >> Not sure what you data and macro look like but perhaps you only need the >> following >> >> where 1 <= perf <= 6 and acctno=&selection; >> >> vs. >> >> where 1 <= perf <= 6 and &selection; >> >> >> >> On 11/27/06, stulkem <mark.a.stulken@gtservicing.com> wrote: >> > >> > I have an odd problem when using proc means. >> > here's the code: >> > >> > proc means data=test n completetypes missing nonobs; >> > where 1 <= perf <= 6 and &selection; >> > class cyc1_score/preloadfmt exclusive order=data; >> > var acctno; >> > format cyc1_score testscore.; >> > run; >> > >> > output in 3 of 4 macro passes (macro for '&selection'): >> > >> > Analysis Variable : acctno >> > cyc1_score N >> > --------------------------- >> > (01) Low to -51 0 >> > (02) -50 to 0 2 >> > (03) 0 to 49 1 >> > (04) 50 to 99 0 >> > (05) 100 to 149 6 >> > (06) 150 to 199 13 >> > (07) 200 to 249 16 >> > etc........ >> > >> > Here's the results of the fourth macro pass, which seems to be in an >> > infinite loop because I have to manually stop the process. The code >> > works with no problems on the first 3 passes. My first guess is that >> > there is a problem with my data, but I have made sure that is not the >> > case. What is happening here? Doesn't anyone know how proc means is >> > producing these results??? Thanks in advance, Mark: >> > >> > Analysis Variable : acctno >> > >> > cyc1_score N >> > -------------------------- >> > (17) 101 to 150 0 >> > (20) Low to 0 0 >> > (20) Low to 0 0 >> > (19) 1 to 50 0 >> > (18) 51 to 100 0 >> > (17) 101 to 150 0 >> > (16) 151 to 200 0 >> > (15) 201 to 250 0 >> > (18) 51 to 100 0 >> > (17) 101 to 150 0 >> > (14) 251 to 200 0 >> > (18) 51 to 100 0 >> > (15) 201 to 250 0 >> > (16) 151 to 200 0 >> > (15) 201 to 250 0 >> > (15) 201 to 250 0 >> > etc...., >> >


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