https://communities.sas.com/t5/SAS-Programming/Duration-in-days/m-p/350638#M81521 <P>The following would do what you want:</P> <P>&nbsp;</P> <PRE>data have; informat Bookingdate datetime19.; informat Departuredate yymmdd10.; input Bookingdate Departuredate; Duration=Departuredate-datepart(Bookingdate); cards; 21dec15:22:33:58 2016-01-04 26dec15:12:25:17 2015-12-28 ; </PRE> <P>Art, CEO, AnalystFinder.com</P> Mon, 17 Apr 2017 20:34:51 GMT art297 2017-04-17T20:34:51Z https://communities.sas.com/t5/SAS-Programming/Duration-in-days/m-p/350632#M81519 <P>I have two date column as shown below, I want to create duration in terms of days.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Bookingdate</TD><TD>Departuredate</TD><TD>Duration</TD></TR><TR><TD>21dec15:22:33:58</TD><TD>2016-01-04</TD><TD>&nbsp;</TD></TR><TR><TD>26dec15:12:25:17</TD><TD>2015-12-28</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Mon, 17 Apr 2017 20:14:42 GMT https://communities.sas.com/t5/SAS-Programming/Duration-in-days/m-p/350632#M81519 subrat1 2017-04-17T20:14:42Z https://communities.sas.com/t5/SAS-Programming/Duration-in-days/m-p/350638#M81521 <P>The following would do what you want:</P> <P>&nbsp;</P> <PRE>data have; informat Bookingdate datetime19.; informat Departuredate yymmdd10.; input Bookingdate Departuredate; Duration=Departuredate-datepart(Bookingdate); cards; 21dec15:22:33:58 2016-01-04 26dec15:12:25:17 2015-12-28 ; </PRE> <P>Art, CEO, AnalystFinder.com</P> Mon, 17 Apr 2017 20:34:51 GMT https://communities.sas.com/t5/SAS-Programming/Duration-in-days/m-p/350638#M81521 art297 2017-04-17T20:34:51Z