How to calculate datetime difference between two date values in minutes and hours

smunigala — Thu, 12 Nov 2015 17:57:29 GMT

Hi all,

I need help (SAS code) in calculating difference in minutes and hours for datetime variables. I have attached a copy of my data.

Here I have several Reg_Nos and the corresponding culture_dates (datetime). Some of the Reg_nos have multiple culture_date which are in different row compared to the first culture_date for that Reg_no (eg. I have highlighted in red).

I need to find the difference in minutes and hours from the first culture_date to the next cultre_date if a Reg_No has more than one culture_date.

Thanks for the help!

Satish

Re: How to calculate datetime difference between two date values in minutes and hours

LinusH — Fri, 13 Nov 2015 13:10:06 GMT

To be able to calculate this between observations, use a data step with BY, first./last. processing.

Retain previous observation datetime (if the same reg_no).

A simple subtraction will give you the no of seconds between timestamps. Apply time format for display of choice.

If you need to add more rules to the calculation, ta look at INTCK() function.

topic How to calculate datetime difference between two date values in minutes and hours in SAS Data Management

How to calculate datetime difference between two date values in minutes and hours

Re: How to calculate datetime difference between two date values in minutes and hours