DateDiff

[Eugenio211]

Hello, hope everyone is safe.

I have this data set and I want to flag a Customer_Key that have 3 consecutive datediff of less 1.  What I'm trying to get is a customer that have a 3 or more transactions within a 2 day period.  Thank you in advance.

[vellad · Accepted solution]

Try this (made a small edit - see comment):

libname here '.';
proc import datafile="Data_Example.xlsx" out=have dbms=xlsx replace;
run;   
proc sort; 
     by customer_key; 
run;
data want;
     retain window cnt;
     set have;  
     by customer_key;
     if first.customer_key then do; 
          cnt=0; window=0; 
     end;
     if window + datediff <= 2 then do; 
          cnt=cnt+1; window = window + datediff;
     end;
     else do; 
          window=0; cnt = 1; /*changed cnt=0 to cnt=1*/
     end;
     if cnt >= 3 then flag='Y';
 run;

[Eugenio211]

Thank you, It worked as I expected.