→
data a;
input id$ aa$ bb;
cards;
3 1 da
3 2 22
1 1 123
1 2 113
2 1 22
2 2 33
;
run;
proc sort data=a;by id ;run;
proc transpose data=a out=aaaa(drop=_:) prefix=value_;
by id;
var bb;
run;
→
data a;
input id$ aa$ bb;
cards;
3 1 da
3 2 22
1 1 123
1 2 113
2 1 22
2 2 33
;
run;
proc sort data=a;by id ;run;
proc transpose data=a out=aaaa(drop=_:) prefix=value_;
by id;
var bb;
run;