topic Re: Calculating Date difference in Day in SAS Programming

Calculating Date difference in Day

mlogan — Tue, 31 Mar 2015 19:36:36 GMT

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

Re: Calculating Date difference in Day

Steelers_In_DC — Tue, 31 Mar 2015 19:49:58 GMT

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

Re: Calculating Date difference in Day

Astounding — Tue, 31 Mar 2015 22:36:26 GMT

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.

Re: Calculating Date difference in Day

MichelleHomes — Wed, 01 Apr 2015 02:29:44 GMT

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