11-12-2015 12:57 PM
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!
11-13-2015 08:10 AM
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.