DATA Step, Macro, Functions and more

Performance tuning techniques

Reply
Contributor
Posts: 22

Performance tuning techniques

Hi All,
I want to know performance tuning techniques in SAS and
How we use this techniques in SAS.
Kindly explain with examples.
Thank in advance
Super User
Posts: 9,612

Re: Performance tuning techniques

Posted in reply to bollurajkumar

The first step is determining where your codes perform less than optimal. The insights gained this way will guide you.

 

So start out by thoroughly inspecting your logs, using the fullstimer option.

 

Try different methods to solve a specific problem, and compare their performance.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
PROC Star
Posts: 1,193

Re: Performance tuning techniques

Posted in reply to bollurajkumar

This is a very broad question. Post an example of the code you are using and explain what parts of it you want to optimize.

Super User
Posts: 10,626

Re: Performance tuning techniques

Posted in reply to bollurajkumar

You are talking about Decision Tree ? Post it at Enterprise Miner forum.

Super User
Posts: 5,829

Re: Performance tuning techniques

Posted in reply to bollurajkumar
Just out of curiosity @Ksharp, how did you figure Decision Tree from that post?

@bollurajkumar: there are literally tons of papers and a subject in many of SAS User Guide documentations. Do some research, and then return with more specific inquiries.
Data never sleeps
Contributor
Posts: 22

Re: Performance tuning techniques

Posted in reply to bollurajkumar
I have a SAS di job.if I run that job it takes around 5 hours to complete run process . Now I want to reduce running process time.which steps can I perform to optimize my SAS di job
Super User
Posts: 9,612

Re: Performance tuning techniques

Posted in reply to bollurajkumar

Look at the log, identify long-running steps, try alternate methods, try setting options. What you need to do is determined by so many factors that no real answer can be given with the little information available.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 5,829

Re: Performance tuning techniques

Posted in reply to bollurajkumar
DI Studio specifics: temporarily change from views to tables as output in transformations, otherwise it's hard to understand what step(s) causes the high resource consumption.
Data never sleeps
Ask a Question
Discussion stats
  • 7 replies
  • 192 views
  • 0 likes
  • 5 in conversation