topic Re: Performance tuning techniques in SAS Programming

Performance tuning techniques

bollurajkumar — Sat, 18 Nov 2017 12:25:22 GMT

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

Re: Performance tuning techniques

Kurt_Bremser — Sat, 18 Nov 2017 12:55:36 GMT

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.

Re: Performance tuning techniques

PeterClemmensen — Sat, 18 Nov 2017 15:06:56 GMT

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.

Re: Performance tuning techniques

Ksharp — Sun, 19 Nov 2017 09:55:02 GMT

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

Re: Performance tuning techniques

LinusH — Sun, 19 Nov 2017 12:46:31 GMT

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.

Re: Performance tuning techniques

bollurajkumar — Sun, 19 Nov 2017 13:07:45 GMT

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

Re: Performance tuning techniques

Kurt_Bremser — Sun, 19 Nov 2017 17:16:22 GMT

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.

Re: Performance tuning techniques

LinusH — Mon, 20 Nov 2017 13:10:03 GMT

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.