Execution Time

Jchapman — Sat, 13 Sep 2014 00:24:03 GMT

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;

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!

Re: Execution Time

jakarman — Sat, 13 Sep 2014 05:56:52 GMT

what you are trying to do is standard part of ARM.
The log4j is a well known interface. APM and Eventmananager are build on top of this. When activated ill you are trying to build is already there.

http://support.sas.com/documentation/cdl/en/armref/62980/HTML/default/viewer.htm#n1x1n1iiwv8l6jn199yr79iaud8m.htm

topic Execution Time in Developers

Execution Time

Re: Execution Time