Being teased a little about my system performance, I decided to look a little closer.
I'm using a single processor machine, which might affect results.
I was testing the run under DM, where calculating total cpu time is inconvenient across 100 steps, let alone 1000!
Under batch SAS9.1 the log shows the totalled time at a more reasonable pace[pre] real time 22.46 seconds
user cpu time 1.49 seconds
system cpu time 2.82 seconds[/pre]
However, under DM there are extra overheads (like EG but different).
To simplify the calculation of total cpu for 1000 creates/deletes, I tested this variation
%macro timetst() ;
%do i = 1 %to 1000 ;
CREATE TABLE tabletest (test int) ;
DROP TABLE tabletest ;
%end ;
%mend timetst ;
proc sql noprint;
%timetst() ;
quit;
This provides times for the single SQL step:[pre]NOTE: PROCEDURE SQL used (Total process time):
real time 18.46 seconds
user cpu time 0.92 seconds
system cpu time 2.10 seconds
Memory 60k [/pre]
Running the code in batch provided these step times[pre]NOTE: PROCEDURE SQL used (Total process time):
real time 15.71 seconds
user cpu time 0.85 seconds
system cpu time 2.42 seconds
Memory 60k[/pre]
There is no way my elapse time would be below 10 secs let alone under 4 secs!
Perhaps I should not load up my machine with so many activities;-)
PeterC