I am updating some old code which previously took 14 hours to improve efficiency. I'm trying to use a Proc Summary with a Class statement instead of sorting the dataset first, followed by a Proc Summary. When I take a small sample of the dataset this Proc Summary works fine, but with the entire dataset it ran for 10 hours before I halted it. Based on the past code I would only expect about a 2-3 hour run time.
When I broke the proc summary, this the run time:
NOTE: PROCEDURE SUMMARY used:
real time 8:07:47.26
cpu time 19:56.10
Any ideas?
... View more