Duration in days

[subrat1]

I have two date column as shown below, I want to create duration in terms of days.

Bookingdate	Departuredate	Duration
21dec15:22:33:58	2016-01-04
26dec15:12:25:17	2015-12-28

[art297]

The following would do what you want:

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
;

Art, CEO, AnalystFinder.com