data ex;
input
(a b c d)($);
cards;
A 1 Ⅰ 900
A 1 Ⅱ 1000
A 2 Ⅰ 1200
A 2 Ⅰ 500
A 2 Ⅱ 1100
B 1 Ⅰ 600
B 1 Ⅱ 700
B 2 Ⅰ 1200
B 2 Ⅰ 500
B 2 Ⅱ 不详
C 1 Ⅰ 600
C 1 Ⅰ 700
C 1 Ⅱ 1200
C 2 Ⅰ 600
C 2 Ⅱ 1300
C 2 Ⅲ 1100
;
run;
proc sort data=ex out=ex1;
by a b c;
run;
data ex2;
set ex;
by a b c;
if ^first.a then a="";
if ^first.b then b="";
if ^first.c then c="";
run;