Time Difference Calculation

[Babloo]

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

[PeterClemmensen]

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

[Patrick · Accepted solution]

@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;