Calculate Time Difference from Datetime Values

[prantsaga]

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.

[Kurt_Bremser]

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 */