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;
![enter image description here](https://i.stack.imgur.com/LAYBG.png)
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;
![enter image description here](https://i.stack.imgur.com/E5xco.png)
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…