data aa;
ctr_name="UK";tt="IT";cate="arr";output;
ctr_name="UK";tt="IT";cate="tou";output;
ctr_name="UK";tt="IT";cate="tra";output;
ctr_name="UK";tt="IT";cate="pas";output;
ctr_name="UK";tt="OT";cate="dep";output;
run;
proc sort data=aa;
by ctr_name tt cate;
run;
data bb;
length country $200.;
set aa;
by ctr_name tt cate;
if first.ctr_name then do; country=ctr_name;output;end;
if first.tt then do; country=tt;output;end;
if first.cate then do; country=cate;output;end;
run;
考的是input的换行读数
data a;
input t$ / C$;
do i=1 to 3;
input x$ y$ z1-z3;
output;
end;
drop i;
datalines;
UK
IT
AT TF 100 200 300
TE IMF 11 22 33
TU IMF 200 300 400
CHN
TT
A X 500 601 700
A X 500 602 700
A X 500 603 700
;
run;