DATA Step, Macro, Functions and more

SAS Code Performance Issues

Reply
New Contributor
Posts: 4

SAS Code Performance Issues

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

Super User
Posts: 6,537

Re: SAS Code Performance Issues

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.
Valued Guide
Posts: 559

Re: SAS Code Performance Issues

Posted in reply to Astounding

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

Ask a Question
Discussion stats
  • 2 replies
  • 157 views
  • 0 likes
  • 3 in conversation