Performance tuning techniques

[bollurajkumar]

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

[Kurt_Bremser]

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.

[PeterClemmensen]

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.

[Ksharp]

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

[LinusH]

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.

[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

[Kurt_Bremser]

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.

[LinusH]

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.