topic Re: SAS Code Performance Issues in SAS Programming

SAS Code Performance Issues

swati428 — Mon, 13 Nov 2017 20:24:00 GMT

Hi friends

What are all the steps to perform in trouble shooting,when users normally have performance issues.

lets a user sas code normally used to run for 15 mins, but its taking now 1 to 2 hrs, what are all the things I need to check

as part of the trouble shooting this issue.

I really appreciate if any one can help me providing detail steps

Thank you

Priya

Astounding — Mon, 13 Nov 2017 20:33:33 GMT

My list is:

Verify that there are zero changes to the code itself.
Check the log to see where the time increase took place, and whether it is an increase in CPU time or an increase in clock time.
Check the size of the incoming data sets to see if that changed.
Check #1 for contention for resources: was there a temporary lack of a resource such as work space.
Check #2 for contention for resources: did another user tie up a key resource input data set, making it unavailable.
If reading from tables, check when stats for those tables were last updated. Reading from tables without stats can take much longer.

ChrisBrooks — Tue, 20 Feb 2018 23:53:34 GMT

I'd add to the list from @Astounding use the FULLSTIMER option which can often give useful clues to the cause of performance problems. You can find further info here -> https://support.sas.com/rnd/scalability/tools/fullstim/index.html