Date: Tue, 14 Aug 2007 19:34:25 -0700
Reply-To: David L Cassell <davidlcassell@MSN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David L Cassell <davidlcassell@MSN.COM>
Subject: Re: Create a Macro list from many records
Content-Type: text/plain; format=flowed
>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
>input polno $8.;
>and I would like a macro list that I can call in my SAS program to be
>generated like below
>Thank you very much in advance
It has already been pointed out that you are probably going about this the
way. I personally would do my best to leave the data in a SAS table and
shove it into a macro variable.
But the question was about a limit on the length of the macro variable.
It looks to me as if you were planning on a big IN clause. That does not
scale well. You would hit the scalability problem well before you got to
the 'too long for a single macro var' problem.
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Now you can see trouble…before he arrives