Date:         Fri, 21 Sep 2001 09:36:10 -0400
Reply-To:     "Diskin, Dennis" <Dennis.Diskin@PHARMA.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Diskin, Dennis" <Dennis.Diskin@PHARMA.COM>
Subject:      Re: decrease waiting time using proc means or proc univariate
Comments: To: Wim Goettsch <wim.goettsch@PHARMO.NL>
Content-Type: text/plain

Guessing here but, you can probably make a great improvement by sorting the
data by CATEGORY and then using a BY CATEGORY in the PROC MEANS instead of
using a CLASS statement.
The sort will probably use a lot less in resources than the CLASS statement
requires.
Try it and you might like it.

hth,
Dennis Diskin

> -----Original Message-----
> From: Wim Goettsch [SMTP:wim.goettsch@PHARMO.NL]
> Sent: Friday, September 21, 2001 9:23 AM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      decrease waiting time using proc means or proc univariate
>
> Hello,
>
> I have a large dataset, 1 mln records (4 variables), 100 MB where I
> need to do proc means or proc univariate on 6000 patients, for every
> patient 200 categories. I want to have a sum, mean etc for every
> category. I have SAS 8.2, Windows Millenium, a pentium 700 Mhz
> processor, 128 MB. When I use proc means or univariate it takes hours
> before the procedure is finished. What do I need to do in order to
> decrease the procedure time?
>
> Thanks,
>
> Wim Goettsch, PhD
> Research Manager
> PHARMO
> Institute for Pharmacoepidemiology and Drug Outcomes Research
> Maliebaan 50
> P.O. Box 85222
> 3508 AE Utrecht, The Netherlands
> Telephone: +31(0)302345743
> Fax: +31(0)302345568
> Mobile: +31(0)654776074
> E-mail: wim.goettsch@pharmo.nl