Programmatically Measure SAS® Application Performance On Any Computer Platform With the New LOGPARSE SAS Macro

From sasCommunity
Jump to: navigation, search
Michael A. Raithel

Westat

Rockville MD

Abstract

For years, SAS programmers have manually combed through their SAS logs to gather the performance metrics of their SAS applications. They take pen in hand and dutifully add up the resource usage of the various [[DATA steps]] and PROC steps of their SAS programs. Sometimes they enter the performance data into a SAS data set or into a spreadsheet so that it can be further analyzed. This process is cumbersome and time consuming. The new, experimental LOGPARSE SAS Macro eliminates the drudgery of obtaining SAS program performance metrics by hand.

The LOGPARSE Macro parses SAS log files and stores SAS performance metrics in a SAS data set. That SAS data set can be used to programmatically report the performance of individual steps within a SAS program, report the performance of the entire SAS program, or report the performance of individual programs within a SAS application. The LOGPARSE Macro can be used to record SAS performance information on any platform that SAS runs on.

This paper introduces the LOGPARSE SAS Macro and shows how to use it. It provides examples of how to use LOGPARSE "out of the box" and how to configure it to fit your needs. This paper presents samples of SAS resource usage reports based on data obtained via the LOGPARSE Macro. After reading this paper, you will be able to download the LOGPARSE SAS Macro from the SAS Institute web site, configure it to your needs, and begin automatically recording and reporting on your SAS application's computer resource usage.

Online materials