Calculating Date difference in Day

[mlogan]

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.

Thanks,

[Steelers_In_DC]

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

[Astounding]

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.

[MichelleHomes]

I suggest reading 's blog post about calculating an age, http://blogs.sas.com/content/sasdummy/2011/07/12/computing-age-in-sas-9-3/ 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,

Michelle

Message was edited by: Michelle Homes