Date:         Tue, 28 Aug 2007 10:27:41 -0500
Reply-To:     Mary <mlhoward@avalon.net>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: ERROR: Overflow has occurred; evaluation is terminated.
Content-Type: text/plain; charset="iso-8859-1"

Rangoon,

Are you really intending to put all the patient numbers into ONE macro variable?   Perhaps you intended to put them into a data set instead?  In that case use the "create table" clause in front of the select statement.  

create table work.patids as
select distinct ptno
        from xx
        where yy in('multi') ;


-Mary
  ----- Original Message ----- 
  From: rangoonraja123@GMAIL.COM 
  To: SAS-L@LISTSERV.UGA.EDU 
  Sent: Tuesday, August 28, 2007 9:34 AM
  Subject: ERROR: Overflow has occurred; evaluation is terminated.


  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.