Date:         Tue, 5 Sep 2006 16:04:55 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: Macro string from Proc Sql: max length exceeded
Comments: To: auto208611@HUSHMAIL.COM
In-Reply-To:  <1157471473.756516.162780@m73g2000cwd.googlegroups.com>
Content-Type: text/plain; format=flowed

Auto ,

Two things along the same lines of thought come to mind:

Proc SQL ;
Select *
   From Master
     Where ID not in ( Select Id from Subset ) ;
Quit ;

Or you could do something like :

Proc SQl ;
Select Master.*
From Master as Master ,
         Subset as Subset
  Where Master.Id = Subset.Id ;
Quit ;



Toby Dunn

When everything is coming at you all at once, your in the wrong lane.

A truly happy person is someone who can smile and enjoy the scenery on a
detour.





From: auto208611@HUSHMAIL.COM
Reply-To: auto208611@HUSHMAIL.COM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Macro string from Proc Sql: max length exceeded
Date: Tue, 5 Sep 2006 08:51:13 -0700

Last week I started this discussion, or at least posted the question
that started the discussion.

http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/962b514ca5b1038b/046f838cfea4c69f?lnk=gst&q=&rnum=1#046f838cfea4c69f

I now get the following error in some instances:

ERROR: The text expression length (97799) exceeds maximum length
        (65534). The text expression has been truncated to 65534
        characters.

  . . . I'm using the string in a Where clause within another Proc Sql.

One solution I tried was to convert the character variable to numeric
so
I wouldn't have to include single or double quotes , there by reducing
the
length of the macro variable, this did not work. . . still exceeds the
length.

Any suggestions, much appreciated.

Thanks.