topic Re: Create a large matrix dataset in New SAS User

Create a large matrix dataset

indra1975 — Mon, 06 May 2019 16:02:45 GMT

I am trying to create a large matrix 6400 x 288 with the following code:

options compress=yes;
data test;
set _null_;
array col(288);
i=1;
do until (i = 6400);
j=1;
do until (j = 288);
col{j}=0;
output;
j=j+1;
end;
i=i+1;
output;
end;
drop i j;
run;

Output Log:

The data set WORK.TEST has 0 observations and 288 variables.

Can someone please help me with improving the above code so that I get 6400 rows and 288 columns? Thanks in advance.

bests

Re: Create a large matrix dataset

PeterClemmensen — Mon, 06 May 2019 18:02:19 GMT

data test(drop= i j);
   array col{288};
   do i=1 to 6400;
      do j=1 to 288;
         col[j]=0;
      end;
      output;
   end;
run;

Re: Create a large matrix dataset

indra1975 — Mon, 06 May 2019 18:11:57 GMT

Thank you. This works as intended.

Re: Create a large matrix dataset

PeterClemmensen — Mon, 06 May 2019 18:42:19 GMT

No problem. Glad you found your answer 🙂

Re: Create a large matrix dataset

PeterClemmensen — Mon, 06 May 2019 18:51:38 GMT

Also, this is simpler btw 🙂

data test(drop= i);
   array col{288} (288*0);
   do i=1 to 6400;
      output;
   end;
run;