- proc format ;
- value $trans 'a'='1'
- 'b'='2';
- run;
- proc transpose data=bbb prefix=col out=ccc(drop=_:);
- var sum;
- id x1 x3;
- by x1 x3;
- format x3 $trans.;
- run;
- data ccc;
- set ccc;
- format x3;
- run;
Obs x1 x3 col11 col12 col22
1 1 a 2 . .
2 1 b . 1 .
3 2 b . . 2