Another way.
data test;
input division$ group$ file$;
datalines;
a t1 1
b m2 5
a t1 1
b m2 5
a t2 3
a t2 3
a t2 4
b m2 6
a t1 2
b m1 6
b m1 6
a t2 4
;
run;
proc sort data = test;
by division group file;
run;
data need;
set test;
retain pstr;
length str pstr $4;
str = cats(division,group,file);
if pstr = str then seq + 1;
else if pstr ^= str then do; seq = 1; pstr = str; end;
run;
... View more
