Subtracting dates by row and id

mmaleta851 — Wed, 23 Jun 2021 22:01:53 GMT

Hi there. I am trying to subtract dates by row as shown here:

PlayerID	Date
1001	12JUN2020
1001	11JUN2020
1002	24AUG2020
1002	13JUL2020
1003	17MAY2021

What I want is this:

PlayerID	Date	DateDiff
1001	12JUN2020	.
1001	11JUN2020	1
1002	24AUG2020	.
1002	13JUL2020	42

However, when I run this code

data table;
input PlayerID$ Date:date9.;

format Date date9.;
datalines;
1001 12JUN2021
1001 11JUN2021
1002 24AUG2020
1002 13JUL2020
;
pro sort data = table;

by PlayerID Date DESC;

run;

data datediff;
set table;
by PlayerID;
daydiff=abs(dif(Date));
if not first.PlayerID then output;
run;

It substracts the previous date regardless like this:

PlayerID	Date	DateDiff
1001	12JUN2020
1001	11JUN2020	1
1002	24AUG2020	223
1002	13JUL2020	42

Any ideas on how to resolve this?

Re: Subtracting dates by row and id

PaigeMiller — Wed, 23 Jun 2021 22:14:24 GMT

daydiff=abs(dif(Date));
if first.PlayerID then daydiff=.;

topic Subtracting dates by row and id in SAS Programming

Subtracting dates by row and id

Re: Subtracting dates by row and id