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

[rinsabraham]

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.

[PGStats]

Please provide example input data and desired output.

[Kurt_Bremser]

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?

[rinsabraham]

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

[rinsabraham · Accepted solution]

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;