|Date: ||Mon, 3 Jun 2002 16:56:03 -0400|
|Reply-To: ||"Fehd, Ronald J." <rjf2@CDC.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Fehd, Ronald J." <rjf2@CDC.GOV>|
|Subject: ||Re: efficiency expertise needed|
> From: Karen Olson [mailto:karen.olson@TCH.HARVARD.EDU]
from your earlier posts I remember that you're working with proc FREQ.
Consider the possibility of creating one cross-tab with the maximum number
PROC FREQ data = LIBRARY.ENORMOUS;
tables M * N * O * P * Q ...
out = LIBRARY.XTAB
(drop = Percent
rename = (Count = Weight);
Any lesser cross-tab can be produced from XTAB
using the weight statement:
PROC FREQ data = LIBRARY.XTAB
tables ...;%*any vars, any order from above list;
This is drill-down in action.
Ron Fehd the macro maven CDC Atlanta GA USA RJF2@cdc.gov
By using your intelligence
you can sometimes make your problems twice as complicated.
-- Ashleigh Brilliant