Bench Marking Proc Summary

From sasCommunity

This article shows programs used to bench mark Proc Summary.

This program ProcSmry-call-exec is called repetitively by DOS-for-loop.bat or Call-Exec-Suite.bat

rem ProcSmry-call-exec.bat
sas ProcSmry-call-exec

*name: ProcSmry-call-exec.sas;
%Let CxData     = Library.ListNames_num;
%Let CxIncludes = Project(ProcSmry)/nosource2;
%Include SiteIncl(CallExecInclude)/nosource2;

Note: this program creates an output data set, no listing is created.

*name: ProcSmry.sas;

PROC Summary data   = &LibName..&MemName.;
             var      &Name.;
             output
                out = Summary
            (  drop =  _Type_  _Freq_)
   n       (&Name.) = n        %*;
   min     (&Name.) = min      %*;
   mean    (&Name.) = mean     %*;
   median  (&Name.) = median   %*p50;
   max     (&Name.) = max      %*;
%*;nmiss   (&Name.) = nmiss    %*;
%* skewness(&Name.) = skewness %*;
%* stddev  (&Name.) = stddev   %*;
%* stderr  (&Name.) = stderr   %*;
   ;
run;

[edit] Results

Note:

• v9_01_01M3: v9.1.3, Service Pack 4
• v9_02_01M0: v9.2

Fehd: Bench Mark Suite
JobTimes-by-version
Report of Comparison of Program JobTimes by Version

                                              v9_01_     v9_02_
Program                    Statistic            01M3      01M0

ProcSmry-call-exec         n                   55.00     55.000
                           mean               813.34    122.025
                           std                430.47     33.399
                           max               3709.46    336.297
                           median             672.55    112.327
                           min                226.61    110.422
                           FreqMode1         1062.50    112.297
                           FreqModePrcnt1       1.82      3.636
                           FreqMode2          983.75    111.750
                           FreqModePrcnt2       1.82      1.818
                           FreqMode3          654.38    116.750
                           FreqModePrcnt3       1.82      1.818

--macro maven == the radical programmer 10:30, 14 April 2008 (EDT)