proc sql;
create table tmp_transpose as
select id,
max(case when term=2151 then term else . end) as v2151,
max(case when term=2155 then term else . end) as v2155
from tmp
group by 1
;
quit;
proc print noobs;
run;
方法2
proc transpose data=tmp out=tmp_new;
by id;
id term;
var term;
run;