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