Date: Fri, 19 Dec 2008 08:54:16 -0500
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Mike Zdeb <msz03@ALBANY.EDU>
Subject: Re: is there an upper limit to items in proc format (using for
hi ... when a format is used, it is moved from a catalog to memory
so, format size limited by available memory (as far as I can remember)
exactly how you can determine the amount of memory available for a format is left up to someone else on the list
ps remember, the bigger the format, the longer the search ... take a look at ...
U@Albany School of Public Health
One University Place
Rensselaer, New York 12144-3456
> in using something like this to later match or delete some data, is there an upper
> limit to how many items can be stored ?
> I know this can be done in proc sql but am wondering if there is some limit like 99999
> rows ?
> finally, is there a better way of doing this /
> data temp;
> retain fmtname 'kkk';
> retain type 'c';
> set mydataset end=eof;
> if eof then do;
> proc format cntlin=temp;
> then in a data step later
> if PUT(myvar,$kkk.)='Y' then .... either output or delete something