The desired data transformation is a easily accomplished with Proc TRANSPOSE
.
proc transpose data=club out=stage(rename=_name_=YR);
by name;
id Gov_type;
run;
If the transform is for reporting purposes considering using Proc TABULATE
proc tabulate data=club;
class name gov_type;
var yr1-yr3;
table name=''*(yr1-yr3)*sum=' '*f=9.,gov_type;
run;
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…