topic Re: How to calculate difference between two dates in different row and column? in SAS Programming

How to calculate difference between two dates in different row and column?

huhuhu — Wed, 25 Sep 2019 17:50:04 GMT

Hello,

I'm wondering if there is a way to calculate the difference between two dates in different variables listed in different rows. My data looks like below:

MemberID InDate OutDate

1 1/1/2019 1/3/2019

1 1/4/2019 1/7/2019

2 1/15/2019 1/16/2019

2 1/20/2019 1/25/2019

Result that I'd like to have is

MemberID InDate OutDate IntervalDays

1 1/1/2019 1/3/2019 .

1 1/4/2019 1/7/2019 1 (difference between 1/4/2019 and 1/3/2019)

2 1/15/2019 1/16/2019 .

2 1/20/2019 1/25/2019 4(difference between 1/20/2019 and 1/16/2019)

Any advice will be helpful!!

Thank you!

Re: How to calculate difference between two dates in different row and column?

Kurt_Bremser — Wed, 25 Sep 2019 17:51:08 GMT

Use the lag() function to retrieve the value of a variable from the preceding observation.

Re: How to calculate difference between two dates in different row and column?

Jagadishkatam — Wed, 25 Sep 2019 18:32:47 GMT

Please try

data have;
input MemberID   InDate:mmddyy10.     OutDate:mmddyy10.;
format InDate OutDate date9.;
cards;
1 1/1/2019   1/3/2019
1 1/4/2019   1/7/2019
2 1/15/2019  1/16/2019
2 1/20/2019  1/25/2019
;

proc sort data=have;
by memberid indate outdate;
run;

data want;
set have;
by memberid indate outdate;
intervaldays=InDate-lag(OutDate);
if first.memberid then intervaldays=.;
run;

Re: How to calculate difference between two dates in different row and column?

huhuhu — Mon, 02 Dec 2019 16:34:45 GMT

Thank you!