|
Does do over actually allow you to do that (iterate through two arrays at
once)? If so, that's pretty interesting and useful to know :)
If not, you would just use:
do i = 1 to 3;
...
end;
(or 1 to whatever your upper limit of variable is).
-Joe
On Tue, Dec 2, 2008 at 2:27 PM, Akshaya Nathilvar <
akshaya.nathilvar@gmail.com> wrote:
> 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
> >
>
| 
