topic Re: i want to track job start time and end time excluding sleep time calculation in SAS Data Management

i want to track job start time and end time excluding sleep time calculation

rinsabraham — Wed, 09 Aug 2017 03:00:18 GMT

we have batch report which run daily at 12:00 ist which need small changes.

in the cureent batch report it calculate overall time taken as starting from 12;00 ist from till the end of job completion which include sleep time also .

can you help me how can exclude sleep time calculation so that it should provide extact batch report.

i am new to sas enivornment.i m bit worry to do can anyone help me out.

Re: i want to track job start time and end time excluding sleep time calculation

PGStats — Wed, 09 Aug 2017 03:56:27 GMT

Please provide example input data and desired output.

Re: i want to track job start time and end time excluding sleep time calculation

Kurt_Bremser — Wed, 09 Aug 2017 06:42:45 GMT

Please post code to illustrate the issue.

Especially define "sleep time". Is it time spent in sleep() functions, or the difference between CPU time and real time?

Re: i want to track job start time and end time excluding sleep time calculation

rinsabraham — Fri, 11 Aug 2017 01:09:01 GMT

Thanks for reply I got the result.
I try to fetch the data from table and took the difference between two times

Re: i want to track job start time and end time excluding sleep time calculation

rinsabraham — Mon, 14 Aug 2017 14:34:37 GMT

I got the solution:
Below is the code:
Proc sql;
Select max(start_time)-max(end_time) from table name where column = sleep time:
Quit;