I am trying to have SAS compute execution time for a stored process which simply includes a SAS program file. I was able to do this with very simple program but when the program was more complex (includes macros, sql junk, etc) I have problems. SAS for some reason does not create a data file? Also, do stored processes have a macro variable defined for execution time that I can access?
Code registered as stored process in metadata follows:
%global startdatetime;
%global executeSAStime;
%let startdatetime= %sysfunc(datetime());
%put &startdatetime;
%STPBEGIN;
%include "C:\code\goes\here.sas";
%put &startdatetime;
%let executeSAStime= %sysfunc(round(%sysevalf(%sysfunc(datetime())-&startdatetime),0.01));
%put &executeSAStime;
%let rc=0;
%include "D:\SAS\users\jchapman1\test\append.sas";
%STPEND;
;
quit;
The append program creates a dataset and appends it to a sql database. However, the datastep used does not seem to be making the dataset for the complex program while it does for the simple one. Very confusing.
400 +%put &_METAUSER;
thisisme@safdasdf
401 +%put &_username;
Test User
402 +%put &_program;
/Shared Data/StoredProcName
403 +%put &startdatetime;
1726172330.329
404 +%put &executeSAStime;
176.38
405 +%put &rc;
0
406 +
407 +*create dataset;
408 +data newtempfile;
409 +length client username $16. Program $30. datetime exectime rc 8. ;
410 +client="&_METAUSER.";
411 +username="&_username.";
412 +program="&_program.";
413 +datetime=&startdatetime.;
414 +exectime=&executeSAStime.;
415 +rc=&rc.;
416 +run;
NOTE: The data set WORK.NEWTEMPFILE has 0 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
Please help!
