Date:         Fri, 11 Feb 2005 15:12:15 -0800
Reply-To:     cassell.david@EPAMAIL.EPA.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "David L. Cassell" <cassell.david@EPAMAIL.EPA.GOV>
Subject:      Re: PROC SURVEYFREQ
In-Reply-To:  <200502112034.j1BKYKK9029951@listserv.cc.uga.edu>
Content-type: text/plain; charset=US-ASCII

David Dorsky <ddorsky@ODH.OHIO.GOV> wrote:
> Does anyone have any ideas on how to make PROC SURVEYFREQ run more
quickly
> and efficiently?  It seems to use an extraordinary amount of CPU and
disk
> space, even with relatively small data sets. I've tried adjusting the
> SUMSIZE parameter as several have suggested, but every adjustment I
tried
> made it worse!  The procedure takes hours to run (if it runs at all)
when I
> try to include more than two or three variables at a a time in the
TABLES
> statement.

I haven't seen this problem before.  (At least, not with SAS 9.1.x -
don't ask about using the experimental version of PROC SURVEYFREQ in
SAS 9.0 !)

How big are your input data sets?
How big are the tables you are creating?  (r by c <by...>)
How many tables are you trying to create at one time?
Have you talked to your SAS site rep or SAS tech support about this?

David
--
David Cassell, CSC
Cassell.David@epa.gov
Senior computing specialist
mathematical statistician