topic Re: Time Difference Calculation in SAS Programming

Time Difference Calculation

Babloo — Mon, 13 May 2019 08:26:53 GMT

I would like to get the answer as 1 hour or 60 minutes if I find the difference between following times.

12MAY2019 11:15 pm
13MAY2019 12:15 am

Re: Time Difference Calculation

PeterClemmensen — Mon, 13 May 2019 08:48:41 GMT

Use INTCK Function with the 'dtminute' or 'dthour' as the first argument.

Re: Time Difference Calculation

Patrick — Mon, 13 May 2019 09:00:56 GMT

@Babloo

If your values are stored as SAS Datetime values then you can simply subtract the the later from the earlier Datetime value. This gives you the difference in seconds. Then apply whatever time format suits you best for printing the result.

data sample;
  start_dttm='12MAY2019 23:15:00'dt;
  stop_dttm='13MAY2019 00:15:00'dt;
  diff=stop_dttm-start_dttm;
  format diff hhmm5.;
  output;
  stop;
run;