Calculate times on test session

[HansSteenhuis]

Hello,

I have certain test sessions with a start and end time. Different tests are performed on the session. These tests also have a beginning and an end time.

Now I want to calculate how much time before, within and after the session falls. The hours and minutes may also be in decimals.

I calculate this in Excel, but I want to calculate this in EG now. Do you see opportunities to make this possible? In EG these are two separate tables (Sessions and To_test).

See my example in Excel.

Thank you very much.

[tomrvincent]

I found this here: https://blogs.sas.com/content/sgf/2015/01/21/sas-timer-the-key-to-writing-efficient-sas-code/

Get your own SAS timer

1. At the very beginning of your SAS program, place the following line of code that effectively starts the timer and remembers the start time:

/* Start timer */

%let _timer_start = %sysfunc(datetime());

2. At the end of your SAS program place the following code snippet that captures the end time, calculates duration and outputs it to the SAS Log:

/* Stop timer */

data _null_;

  dur = datetime() - &_timer_start;

  put 30*'-' / ' TOTAL DURATION:' dur time13.2 / 30*'-';

run;

The resulting output in the SAS log will look like this:

------------------------------

 TOTAL DURATION:   0:01:31.02

------------------------------