LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2011, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 7 Feb 2011 20:58:22 +0000
Reply-To:     "Fehd, Ronald J. (CDC/OCOO/ITSO)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (CDC/OCOO/ITSO)" <rjf2@CDC.GOV>
Subject:      Re: checking efficiency by running codes, reliable?
Comments: To: bbser 2009 <>
In-Reply-To:  <000001cbc58a$d5cd6e80$81684b80$@com>
Content-Type: text/plain; charset="us-ascii"

BenchMarking is a non-trivial pursuit:

Bench Marking Results Comparing v9-1 and v9-2

Tiny url:

Ron Fehd the bench ... maven

-----Original Message----- From: [] On Behalf Of bbser 2009 Sent: Saturday, February 05, 2011 6:17 PM To: Subject: checking efficiency by running codes, reliable?

We usually compare efficiency of different codes by direct running them. Do you think such a method is reliable? I doubt it based on this fact: I ran the same code three times and got three very distinct sets of cpu and real times. What happened? Thanks.



2873 proc sql; 2874 select 2875 destination, 2876 average, 2877 max, 2878 late/(late+early) as Prob 2879 from( select 2880 destination, 2881 avg(delay) as average, 2882 max(delay) as max, 2883 sum(delay>0) as late, 2884 sum(delay<=0) as early 2885 from sasuser.flightdelays 2886 group by destination) 2887 order by average 2888 ; NOTE: Writing HTML Body file: sashtml147.htm 2889 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.13 seconds cpu time 0.05 seconds

2901 proc sql; 2902 select 2903 destination, 2904 average, 2905 max, 2906 late/(late+early) as Prob 2907 from( select 2908 destination, 2909 avg(delay) as average, 2910 max(delay) as max, 2911 sum(delay>0) as late, 2912 sum(delay<=0) as early 2913 from sasuser.flightdelays 2914 group by destination) 2915 order by average 2916 ; NOTE: Writing HTML Body file: sashtml149.htm 2917 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds

2918 proc sql; 2919 select 2920 destination, 2921 average, 2922 max, 2923 late/(late+early) as Prob 2924 from( select 2925 destination, 2926 avg(delay) as average, 2927 max(delay) as max, 2928 sum(delay>0) as late, 2929 sum(delay<=0) as early 2930 from sasuser.flightdelays 2931 group by destination) 2932 order by average 2933 ; NOTE: Writing HTML Body file: sashtml150.htm 2934 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.04 seconds cpu time 0.00 seconds

Back to: Top of message | Previous page | Main SAS-L page