|
One possible solution:
Data have;
input ID $ A1 A2 A3 B1 B2 B3;
cards;
QQ 1 2 3 5 2 4
GG 3 8 3 6 7 4
WW 4 5 6 6 1 8
;
Data want;
set have;
array abc a1-a3;
array xyz b1-b3;
do over abc;
A=abc;
B=xyz;
output;
end;
keep ID A B;
Run;
Akshaya
On Tue, Dec 2, 2008 at 2:55 PM, Ruby <windofoct@gmail.com> wrote:
> Hello folks,
>
> Does anybody know how to transpose the data? I extracted my data in a
> simple way as showed below. As always, I appreciate all your helps
> very much.
>
> ID A1 A2 A3 B1 B2 B3
> QQ 1 2 3 5 2 4
> GG 3 8 3 6 7 4
> WW 4 5 6 6 1 8
>
> ID A B
> QQ 1 5
> QQ 2 2
> QQ 3 4
> GG 3 6
> GG 8 7
> GG 3 4
> WW 4 6
> WW 5 1
> WW 6 8
>
| 
