Calculate Time Difference from Datetime Values

prantsaga — Mon, 17 Apr 2023 06:53:44 GMT

I am struggling! Ive been working with SAS for a few weeks now, learning new stuff every day and it feels great. I'm stuck at the moment.

I have two columns of datetimes (format datetime16.) And I want to subtract the second column from the first to calculate the cycle time between both of them in hh:mm format (the cycle time range is very large... ie. ranging from zero minutes to 2000 hours or larger)

I can't for the life understand what the best method to do this. I have 275,000 rows of data.

Re: Calculate Time Difference from Datetime Values

Kurt_Bremser — Mon, 17 Apr 2023 06:59:19 GMT

I moved your post to a new topic. Please do not attach questions to resolved topics.

Use a simple subtraction, and assign a suitable format:

diff = time2 - time1; /* results in the difference in seconds */
format diff time8.; /* displays in human-readable form */

topic Calculate Time Difference from Datetime Values in SAS Programming

Calculate Time Difference from Datetime Values

Re: Calculate Time Difference from Datetime Values