And here is solution 🙂
data have;
infile datalines;
input cust_id month;
datalines;
1 2
1 3
1 4
1 5
1 8
1 9
1 10
1 11
1 12
;
run;
data want (drop=p_month);
set have;
by cust_id;
retain flg p_month;
if first.cust_id then flg=1;
else if month ne p_month+1 then flg=0;
p_month=month;
run;
... View more
