Date:         Mon, 9 Sep 2002 14:14:49 GMT
Reply-To:     CKalisetty <ckalisetty@AOL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         CKalisetty <ckalisetty@AOL.COM>
Organization: AOL http://www.aol.com
Subject:      proc sql or data step

Hello all

I have to sum up variables in a dataset that has some 30 million observations.
Right now we are using proc sql to do it. But, it is taking a lot of time. How
Can I improve the performance? Can I use data step with retain? Are there any
other solutions?
Any suggestions?
Any help is greatly appreciated.
Thanks
Sekhar