Date:         Thu, 9 Sep 2010 18:54:40 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Access "IN(IS NULL, '2' " question........
Comments: To: Craig Johnson <cjohns38@GMAIL.COM>

Craig,

Have you tried something like?:

libname x "c:\db1.mdb";
PROC SQL;
  Select*
    From x.Y
      Where missing(variable) or variable in ("2");
QUIT;

Art
---------
On Thu, 9 Sep 2010 14:43:03 -0500, Craig Johnson <cjohns38@GMAIL.COM>
wrote:

>Is there a trick to getting the IS NULL option to pass through to access
and
>work in an IN operator?  For example.......
>
>PROC SQL;
>Select*
>From X.Y
>Where Variable In(Is Null, '2');
>QUIT;
>
>I can't figure out how to get it work or if it is even possible (
>http://www.devx.com/vb2themax/Tip/18541).  Yes, I realize I could rewrite
>the code a couple of different ways it just seems like I should be able to
>add the "Is Null" option in.............
>
>Thoughts?