A Simple VVALUEX perhaps?
data have;
input Col_src $ A B C D E F;
cards;
A 1 2 3 4 5 6
B 1 2 3 4 5 6
D 1 2 3 4 5 6
C 1 2 3 4 5 6
;
data want;
set have;
Col_val=vvaluex(Col_src);
run;
Col_src
A
B
C
D
E
F
Col_val
A
1
2
3
4
5
6
1
B
1
2
3
4
5
6
2
D
1
2
3
4
5
6
4
C
1
2
3
4
5
6
3
... View more
