BookmarkSubscribeRSS Feed
thanikondharish
Fluorite | Level 6

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)

1 REPLY 1
PaigeMiller
Diamond | Level 26
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.

--
Paige Miller
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 563 views
  • 0 likes
  • 2 in conversation