SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Contributor
Posts: 59

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

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

Super User
Posts: 5,257

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

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.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 440 views
  • 0 likes
  • 2 in conversation