topic Re: DateDiff in SAS Programming

DateDiff

Eugenio211 — Tue, 08 Dec 2020 19:00:12 GMT

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.

Re: DateDiff

vellad — Tue, 08 Dec 2020 20:51:23 GMT

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;

Re: DateDiff

Eugenio211 — Wed, 09 Dec 2020 17:06:28 GMT

Thank you, It worked as I expected.