Calculating Date difference in Day

Regular Contributor
Posts: 244

Calculating Date difference in Day

Can anyone tell me the code how to create a new variable (Day_Diff) and calculate the day difference between Start_Date and End_Date of the following table?

My dates are Numeric and Date9. format.

ID    Start_Date  End_Date

1     12/01/2014  12/14/2014

1     01/01/2014  01/06/2014

1     01/01/2014  01/06/2014

1     10/01/2012  10/05/2012

2     01/01/2014  01/05/2014

2     12/01/2014  12/03/2014

2     12/01/2014  12/07/2014

2     02/11/2014  02/15/2014

2     01/01/2014  01/11/2014

I would much appreciate your help.


Valued Guide
Posts: 864

Re: Calculating Date difference in Day

day_diff = intck('day',start_date,end_date);

Super User
Posts: 6,785

Re: Calculating Date difference in Day

Perhaps more simply, you could code:

days_diff = end_date - start_date;

SAS stores its dates on a numeric integer scale, where each passing day is one more than the day before.

Trusted Advisor
Posts: 1,403

Re: Calculating Date difference in Day

I suggest reading 's blog post about calculating an age, Depending on your SAS version and your precision requirement, there are many ways.

>>> Oops! Just realised you were asking about days... a simple subtraction will work. I thought you were referring to years. :smileyblush:

Kind Regards,


Message was edited by: Michelle Homes

Ask a Question
Discussion stats
  • 3 replies
  • 4 in conversation