topic column vector to matrix in SAS Programming

column vector to matrix

greenhousemilk — Fri, 19 Oct 2012 20:39:31 GMT

Hello I have following data (column vector)

1060

1061

530000

I want to make it

500*1060 matrix.

Any help appreciated.

Re: column vector to matrix

Linlin — Fri, 19 Oct 2012 21:11:52 GMT

data have;

do i=1 to 530000;

output;

end;

data want;

set have;

group=int((_n_-1)/1060);

proc transpose data=want(keep=col:);

var i;

by group;

run;

proc print;run;

Re: column vector to matrix

PGStats — Sat, 20 Oct 2012 01:17:41 GMT

Be careful what you wish for...

data have;
do i=1 to 500*1060;
output;
end;
run;

data want;
array x{500, 1060};
do k = 1 to 500;
     do j = 1 to 1060;
          set have;
          x{k,j} = i;
          end;
     end;
drop i j k;
run;