Date:         Fri, 27 Aug 2010 12:35:08 -0700
Reply-To:     Daniel Nordlund <djnordlund@VERIZON.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Daniel Nordlund <djnordlund@VERIZON.NET>
Subject:      Re: A IF or Where Statement problem. So Simple but not working.
              Please help me.
In-Reply-To:  <AANLkTinVncViwUktLFLQywhEDPX3u22GPd=-FMuOyjJy@mail.gmail.com>
Content-type: text/plain; charset=utf-8

> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Joe
> Matise
> Sent: Friday, August 27, 2010 9:56 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: A IF or Where Statement problem. So Simple but not working.
> Please help me.
>
> Please attach your code so we can tell you why it's wrong.  :)
>
> My solution for that would probably involve IF NOT
> MISSING(COALESCE(variables)); if they are all of a type (all numeric/all
> character).
>
> =Joe
>
> On Fri, Aug 27, 2010 at 11:48 AM, Tom Smith <need_sas_help@yahoo.com>
> wrote:
>
> > I meant none of the varaible is not missing, means both variable can
> have
> > value or atleats one of them has a value for a particular record. The
> only
> > recod needed to be deleted where both variable has missing values.
> Thanks
> > a lot.

Or to simplify the logic a bit:

   IF COALESCE(result, category);

Hope this is helpful,

Dan

Daniel Nordlund
Bothell, WA USA