Date:         Fri, 3 Aug 2007 14:13:40 +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: Create a Macro list from many records
Comments: To: shanks.n@GMAIL.COM
In-Reply-To:  <usl7067qt.fsf@gmail.com>
Content-Type: text/plain; format=flowed

It depends, when you try to load too many values into the Macro variable it
wont give you an error, however it will throw a non terminal error depending
on the context in which you try to use the Macro variable.



Toby Dunn

If anything simply cannot go wrong, it will anyway.  Murphys Law #2.

The buddy system is essential to your survival; it gives the enemy somebody
else to shoot at.
Murphys Law #


Tell a man there are 300 billion stars in the universe and he'll believe
you. Tell him a bench has wet paint on it and he'll have to touch to be
sure.  Murphys Law #9






From: Shanks N <shanks.n@GMAIL.COM>
Reply-To: Shanks N <shanks.n@GMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Create a Macro list from many records
Date: Fri, 3 Aug 2007 19:27:30 +0530

"Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET> writes:

 > Thien Thai wrote:
 >> Good morning
 >>
 >> I have the following data in the following format and would like to my
 >> macro list to be like below, is there a limit on the length of the
 >> macro list???
 >
 > Typically Proc SQL select expression into :macrovar separated by ',' is
used
 > to code generate an in-list that can be used in SQL pass through or in an
IN
 > statement.  Since you are wanting for single quotes, this sounds like
 > passthrough.  Macro variables truncate at 64K.  If all your lookup keys
are
 > 8 characters you will be limited to about 5,950 rows in the polno table.
 >
 > If you are worried about limits, however, you shouldn't use the :into
method
 > for codegen.
 >

[...]
I suspect that this limitation aspect '...truncate at 64K' is going to
be lost with a lot of newbies.  I've always wondered when people post
about getting columns into a macro variable that there are these
limits which generated macro variables  run into.

Since their requested data is small and the solution posted by most
people tend to solve for that truncated list, I wonder whether it has
had some ramifications somewhere down the line.

Is there a NOTE in the SAS log when such a limit is reached or does
SAS simply chug along?



  regards,
  Shanks

_________________________________________________________________
Messenger Café — open for fun 24/7. Hot games, cool activities served daily.
Visit now. http://cafemessenger.com?ocid=TXT_TAGHM_AugHMtagline