https://communities.sas.com/t5/SAS-Programming/how-to-pick-difference-between-two-datetime-variables/m-p/608714#M177177 <P>data ex ;<BR />input dob:datetime15. start:datetime15. ;<BR />format dob start&nbsp; datetime15. ;<BR />cards ;<BR />9oct2019:12:50:00 9oct2019:13:55:00</P> <P>9oct2019:12:50:00 10oct2019:13:55:00<BR />;</P> <P>&nbsp;</P> <P>how to do difference between two datetime vaiables&nbsp;</P> <P>ex:&nbsp; &nbsp;1)01:05(one hour and five minutes)</P> Mon, 02 Dec 2019 14:51:27 GMT thanikondharish 2019-12-02T14:51:27Z https://communities.sas.com/t5/SAS-Programming/how-to-pick-difference-between-two-datetime-variables/m-p/608714#M177177 <P>data ex ;<BR />input dob:datetime15. start:datetime15. ;<BR />format dob start&nbsp; datetime15. ;<BR />cards ;<BR />9oct2019:12:50:00 9oct2019:13:55:00</P> <P>9oct2019:12:50:00 10oct2019:13:55:00<BR />;</P> <P>&nbsp;</P> <P>how to do difference between two datetime vaiables&nbsp;</P> <P>ex:&nbsp; &nbsp;1)01:05(one hour and five minutes)</P> Mon, 02 Dec 2019 14:51:27 GMT https://communities.sas.com/t5/SAS-Programming/how-to-pick-difference-between-two-datetime-variables/m-p/608714#M177177 thanikondharish 2019-12-02T14:51:27Z https://communities.sas.com/t5/SAS-Programming/how-to-pick-difference-between-two-datetime-variables/m-p/608723#M177181 <PRE><CODE class=" language-sas">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 ;</CODE></PRE> <P>The difference is a straight subtraction, then you want the difference to be formatted into some format you happen to like.</P> Mon, 02 Dec 2019 15:07:03 GMT https://communities.sas.com/t5/SAS-Programming/how-to-pick-difference-between-two-datetime-variables/m-p/608723#M177181 PaigeMiller 2019-12-02T15:07:03Z