Date:         Tue, 21 Mar 2000 16:18:09 -0500
Reply-To:     Bernard Tremblay <imaginasys@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bernard Tremblay <imaginasys@HOTMAIL.COM>
Subject:      Re: "not in (.,0) " not working in proc sql, creating a view

Hi,

   The problem is simple change the "and" for an "or" in the where clause:

     where smp_info.ID not in (.,0) OR smp_info.SIZE not in (.,0);



   Regards,
         Bernard Tremblay
         imaginasys@hotmail.com