Date:         Tue, 28 Aug 2007 11:14:15 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: ERROR: Overflow has occurred; evaluation is terminated.

That makes no sense! I assume, that there is a limit of around 36,000 bytes
for macro variable lengths, but what do you want with 20,000 numbers in one
macro variable???????
Could you tell us, what you REALLY WANT TO DO - not the way you are trying
to do it?
Gerhard



On Tue, 28 Aug 2007 07:34:35 -0700, rangoonraja123@GMAIL.COM wrote:

>Hi all,
>
>i am having following error in my log
>
>ERROR: Overflow has occurred; evaluation is terminated.
>
>PROC sql noprint;
>        select distinct ptno into: pt separated by ','
>        from xx
>        where yy in('multi') ;
>quit;
>
>This happens when i use this macro variable(pt) from sql in another
>program
>this macro variable (pt) has a value of 20,000 patient numbers
>
>
>
>(eg:  2001, 2002,
>2003,...............................................................................
>and so on).
>
>I need a have a macro variable containing the patient numbers.
>
>how do i over come this.
>
>regards,
>rangoon.