@sofia3 Is the logic you're asking for as simple as below?
data have;
infile datalines dsd truncover;
input Member_ID Purchased_Fruit $ Group $ Count Count_Shift;
datalines;
1,Apples,Female,1,0
1,Apples,Female,2,1
1,Apples,Female,3,2
2,Apples,Female,1,0
2,Apples,Female,2,1
2,Bananas,Female,0,2
2,Bananas,Female,0,0
2,Apples,Female,1,0
2,Apples,Female,2,1
2,Apples,Female,3,2
3,Apples,Male,0,0
4,Pears,Female,0,0
4,Apples,Female,1,0
4,Oranges,Female,0,1
;
data want;
set have;
by Member_ID;
Count_Shift_2= lag(count);
if first.member_id then Count_Shift_2=0;
comp_flg= count_shift_2=count_shift;
run;
proc print data=want;
run;
... View more