data ex ;
input dob:datetime15. start:datetime15. ;
format dob start datetime15. ;
cards ;
9oct2019:12:50:00 9oct2019:13:55:00
9oct2019:12:50:00 10oct2019:13:55:00
;
how to do difference between two datetime vaiables
ex: 1)01:05(one hour and five minutes)
data ex ;
input dob:datetime15. start:datetime15. ;
diff=start-dob;
format dob start datetime15. diff time.;
cards ;
9oct2019:12:50:00 9oct2019:13:55:00
9oct2019:12:50:00 10oct2019:13:55:00
;
The difference is a straight subtraction, then you want the difference to be formatted into some format you happen to like.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.