Date:         Thu, 9 Sep 2010 23:32:01 -0400
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: Access "IN(IS NULL, '2' " question........
Comments: To: Craig Johnson <cjohns38@GMAIL.COM>
In-Reply-To:  <AANLkTikhHKUS3Xt84qehMEa0kJhtdrKan1x1C0XkwG3x@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

More typically a query would have
     where Variable IS NULL or Variable IN ('2', ....)

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Craig Johnson
Sent: Thursday, September 09, 2010 3:43 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Access "IN(IS NULL, '2' " question........

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?