Bernard, The 32k is apparently set in stone in v6.12 and earlier. According ti SI, v7 has now been doubled to 64k and the only solution is to create multiple macros, each of which cannot exceed 32k (for v6.12 and earlier). Since v7 is not an option here (waiting for v8) I guess the replicate fuction will be seeing a lot of me.

Rgds, Frank

Bernard Tremblay <bernard@CAPITALE.QC.CA> on 03/19/99 11:31:15 AM

Please respond to Bernard Tremblay <bernard@CAPITALE.QC.CA>

To: SAS-L@UGA.CC.UGA.EDU cc: (bcc: Frank Mwaniki/PH/Novartis) Subject: Re: maximum record length

Hi,

I think the 32K limits is an old thing. I can't find any reference to it in the "SAS guide to macro processing". In version 6 book, it is written: "the length can range from 0 bytes to the amount of memory currently available to the SAS system". You should check in the options window what is the value of the MVARSIZE option. Then try to increase this value until you're able to run you code. The MVARSIZE have to be smaller than the memory allocated for SAS (see the memsize config parameter). Try 1048576 (1M) for a start.

Good luck, Bernard Tremblay \\\|/// \\ - - // ( @ @ ) +-----oOOo-(_)-oOOo-------+--------------------------------------+ | Bernard Tremblay | | | La Capitale | Tel: (418) 646-2401 | | | Fax: (418) 646-5960 | | | Int: Bernard.Tremblay@capitale.qc.ca | +-------------------------+--------------------------------------+ | Imaginasys enr | Res: (418) 658-1411 | | | Int: bertrem@quebectel.com | +--------------Oooo-------+--------------------------------------+ oooO ( ) ( ) ) / \ ( (_/ \_) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~ >>>Date: Fri, 19 Mar 1999 09:32:33 -0500 >>>From: Frank Mwaniki <frank.mwaniki@PHARMA.NOVARTIS.COM> >>>Subject: maximum record length >>> >>>Hi _All_, >>>Does anybody know if it is possible to increase the 32K default length >>>allowable in the following procedure? Note this works fine if I only have >>>1,000 to 1,500 ID's I want to put into "LIST" but comes to a screeching >>>halt on approaching the 5,000 to 6,000 range. Any help would be highly >>>appreciated. >>> >>>TIA, >>>Frank >>> >>> >>>185 PROC SQL NOPRINT; >>> >>>186 SELECT QUOTE(TRIM(LEFT(ID))) >>>187 INTO :LIST SEPARATED BY " " >>> >>>188 FROM WORK.ID; >>> >>>ERROR: Record length for object LIST.MSYMTAB in catalog WORK.SASST0 >>>exceeds maximum record length allowed. >>>ERROR: Record length for object LIST.MSYMTAB in catalog WORK.SASST0 >>>exceeds maximum record length allowed. >>>ERROR: Record length for object LIST.MSYMTAB in catalog WORK.SASST0 >>>exceeds maximum record length allowed. >>>189 QUIT; >>> >>>NOTE: The PROCEDURE SQL used 0.66 CPU seconds and 7281K.