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.
>