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 (August 2008, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 6 Aug 2008 17:42:32 +0530
Reply-To:     Ajay ohri <ohri2007@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ajay ohri <ohri2007@GMAIL.COM>
Subject:      Re: exclude the zeros in proc means
Comments: To: Madan Gopal Kundu <Madan.Kundu@ranbaxy.com>
In-Reply-To:  <0BB06F3A14F47A4894D0C4E2ACB86CD0021C8295@NCORP-MSG-CLS.Ranbaxy.com>
Content-Type: text/plain; charset=ISO-8859-1

I meant it using where clause within the proc means using a <> operator

where var1 <> 0;

On Wed, Aug 6, 2008 at 5:30 PM, Madan Gopal Kundu <Madan.Kundu@ranbaxy.com>wrote:

> > Where clause where? If it is not Proc Means, I don't think it will serve > the purpose. This is because in that case all the dataline with any zero > values will be removed from the analyses. > > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of > ohri2007@GMAIL.COM > Sent: Wednesday, August 06, 2008 5:29 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Re: exclude the zeros in proc means > > can you use the where clause ? that should work too. > > On 8/6/08, Anindya Mozumdar <anindya.lugbang@gmail.com> wrote: > > On Wed, Aug 6, 2008 at 5:10 PM, Stefan Pohl <stefan.pohl@ish.de> > wrote: > >> And with multiple vars? > > > > It looks using a data step is your only option > > > > > http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/57 > 8c8659ee9aff9c<http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/578c8659ee9aff9c> > > > > (i) The information contained in this e-mail message is intended only > for the confidential use of ohri2007@GMAIL.COM;SAS-L@LISTSERV.UGA.EDU. > This message is privileged and confidential. If the reader of this message > is not the intended recipient or an agent responsible for delivering it to > the > intended recipient, you are hereby notified that you have received this > document in error and that any review, dissemination, distribution, or > copying of this message is strictly prohibited. If you have received this > communication in error, please notify us immediately by e-mail, and delete > the original message. > > > (ii) Madan.Kundu@ranbaxy.com confirms that Ranbaxy shall not be > responsible if this > email message is used for any indecent, unsolicited or illegal purposes, > which are in violation of any existing laws and the same shall solely be > the responsibility of Madan.Kundu@ranbaxy.com and that Ranbaxy shall at > all times be > indemnified of any civil and/ or criminal liabilities or consequences > there. >


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