Dear SAS
We have recently installed SAS on our company network(we use a VM set-up with multiple users on the server - we use SAS analytics pro (not SAS server). mainly Base SAS and EG are used).
The run-times are extremely slow. see log:
NOTE: There were 24868185 observations read from the data set PREP_CUR.BOOK_201606.
NOTE: The data set SUMM.BOOK_SUMMARY_201606 has 2038 observations and 7 variables.
NOTE: PROCEDURE SUMMARY used (Total process time):
real time 3:49.17
cpu time 13.99 seconds
I noticed that the CPU time is much faster than the real time.
can you perhaps tell what the issue might be by looking at the run times? we also find that if 4 users run code at the same time the speed slows down even further.
My gutfeel is that the computations happen fast (CPU time), but then something is happening to make the overall process very slow.
Do you have any suggestions on how we can speed up run-time?
Regards
Conrad.
You would be best off talking to your IT and running tests through the network. 24million observations is a far amount of data and if that is being transmitted anywhere could take a substantial amount of time. You don't mention where the data resides - this should be on the server where the VM's are so that the data is not being moved around. From that little bit of info, it doesn't seem to be the processing which is taking the time, so some network problem.
Well, for I/O purposes a faster disk is always going to speed things up, but a 3.5hr time versus 12 second process seems to be another issue, I think somehow the data and the processor aren't connected optimally. As I say, best to speak with your IT group as they can test the process, see where things are happening.
Doh, don't trust me, I can't even read! 3 minutes isn't too bad then really for 24mill records (am wondering if I read that right now), your IT might be able to suggest some things to speed it up, SSD for instance, or more memory, but overall thats not too bad.
Quick FYI - this isn't 'SAS' if you want an answer from SAS contact tech support.
Processing 24million records in 3 minutes across a network isn't bad though you don't show the actual code so we don't know what els is happening in your data step. Assuming just a quick filter?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.