Date:         Wed, 22 Dec 2010 10:18:20 -0500
Reply-To:     Michael Raithel <michaelraithel@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Michael Raithel <michaelraithel@WESTAT.COM>
Subject:      Re: Timing SAS runs
In-Reply-To:  <COL118-W4602C4E4F9C62BC78142D1F11B0@phx.gbl>
Content-Type: text/plain; charset="us-ascii"

Dear SAS-L-ers,

In response to Andrew Clapson's query, Michelle posted the following:

> There is a handy dandy macro called logparse, there are lots of papers
> on it.
>
> Here is one by SAS-L contributor Michael A. Raithel
>
>
> http://www2.sas.com/proceedings/sugi30/219-30.pdf
>
>
> It takes a log file and extracts statistics for each step in the log.
>
> It can be wrapped in a macro to check multiple folders, output to
> excel, sorted by
> any ascending or descending elapsed or CPU time, and further evaluated
> in
> just about any way you see fit.
>
Michelle, thanks for the good word; I _LOVE_ seeing my name in bright lights:-)

Andrew, in addition to the great advice that Michelle posted, and that Suzanne, John, Chang, Mark, and Tom posted, I have an additional piece of information.  If you are running your applications on z/OS, then you might consider instrumenting the SAS SMF Exit.  That exit directs SAS programs to write PROC and DATA step statistics to records in your system's SMF files.  After that, you can decomp those records using Merrill's MXG or CA-MICS or ask your friendly Systems Performance Analyst for an extract of the relevant tables from said performance packages. Information about the SAS SMF Exit can be found in the installation procedures for SAS under z/OS.

All, best of luck in all your SAS endeavors!

I hope that this suggestion proves helpful now, and in the future!

Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Michael A. Raithel
"The man who wrote the book on performance"
E-mail: MichaelRaithel@westat.com

Author: Tuning SAS Applications in the MVS Environment

Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition
http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172

Author: The Complete Guide to SAS Indexes
http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Seasons Greetings, and wishing you one 'L of a new year! - Michael A. Raithel
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++