Calculate times on test session

HansSteenhuis — Thu, 20 Sep 2018 13:48:19 GMT

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.

Re: Calculate times on test session

tomrvincent — Thu, 20 Sep 2018 14:14:55 GMT

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

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());

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

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

topic Re: Calculate times on test session in SAS Programming

Calculate times on test session

Re: Calculate times on test session

Get your own SAS timer