Date:         Tue, 28 Aug 2007 07:34:35 -0700
Reply-To:     rangoonraja123@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         rangoonraja123@GMAIL.COM
Organization: http://groups.google.com
Subject:      ERROR: Overflow has occurred; evaluation is terminated.
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

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.