topic Re: Record execution time into a dataset in SAS Programming

Record execution time into a dataset

MarcTC — Thu, 09 Jun 2011 21:52:37 GMT

A user can get real time & cpu time info for a proc/data step in the SAS log. But if a program contain many proc/data steps, reading the log to obtain the execution time info become a horrible task. I wonder if there is any way to automatically record the execution time into a SAS dataset with the following layout:

step real_time cpu_time
DATA 1.32 0.88
PROCEDURE 0.44 0.10
PROCEDURE 2.18 0.45
.....

Re: Record execution time into a dataset

Ksharp — Fri, 10 Jun 2011 02:37:50 GMT

You can use proc printto to redirect log into a txt file, then write some code to get information needed.

Ksharp

Re: Record execution time into a dataset

Ksharp — Fri, 10 Jun 2011 02:40:33 GMT

You can use proc printto to redirect log into a txt file, then write some code to get information needed.

Ksharp

Re: Record execution time into a dataset

chang_y_chung_hotmail_com — Fri, 10 Jun 2011 15:05:57 GMT

Instead of parsing the log file, I would recommend using the Application Response
Measurement (ARM) API. This sas-l posting with links may help.
The reference manual is here.

Re: Record execution time into a dataset

MarcTC — Fri, 10 Jun 2011 17:01:20 GMT

Thanks Ksharp & Guru Chung for your input!

Re: Record execution time into a dataset

polingjw — Mon, 13 Jun 2011 10:16:50 GMT

This paper might be of interest to you.

http://www2.sas.com/proceedings/sugi30/219-30.pdf