Calculating Date difference in Day

Reply
Regular Contributor
Posts: 218

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.

Thanks,

Valued Guide
Posts: 858

Re: Calculating Date difference in Day

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

Super User
Posts: 5,367

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,296

Re: Calculating Date difference in Day

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

Ask a Question
Discussion stats
  • 3 replies
  • 248 views
  • 2 likes
  • 4 in conversation