Hi Community!
I am having a difficult time converting Date/Time differences into HH:MM. I want to know how many hours and minutes are between two dates. For instance:
EVENT_CAPTURED_DT_SENT EVENT_CAPTURED_DT_OPEN
02Feb2018 17:31:15.00 01Mar2018 3:40:41.00
I need the output to express the difference in time as.....354:15 (example of HH:MM)
I am currently using the HMS function, but only giving me the difference in time and not the difference between date/time.
Why not just compute the number of hours? (You would have 341.25 instead of 341:15)
It's easy to obtain, and easy to use in computations down the road:
duration_hours = (event_captured_dt_open - event_captured_dt_sent) / 3600;
Why not just compute the number of hours? (You would have 341.25 instead of 341:15)
It's easy to obtain, and easy to use in computations down the road:
duration_hours = (event_captured_dt_open - event_captured_dt_sent) / 3600;
the HHMM. format does it for you:
data test;
sent_dt = '02Feb2018 17:31:15.00'dt;
open_dt = '01Mar2018 3:40:41.00'dt;
interval = open_dt - sent_dt;
format interval hhmm8.;
run;
proc print; run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.