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
Content-Type: text/plain; format=flowed
Two things along the same lines of thought come to mind:
Proc SQL ;
Where ID not in ( Select Id from Subset ) ;
Or you could do something like :
Proc SQl ;
From Master as Master ,
Subset as Subset
Where Master.Id = Subset.Id ;
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
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.
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
. . . 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
I wouldn't have to include single or double quotes , there by reducing
length of the macro variable, this did not work. . . still exceeds the
Any suggestions, much appreciated.