You should include this suggestion in the SASware Ballot Ideas. ... View more

I do not understand the relation between the first matrix and the submatrixes you want to produce so you are right: Mi program does not work for the general case (witch I dont understand). Anyway, I developed a Logic to populate any submatrix NxN from an initial value on. See this same entry in SAS/IML Software and Matrix computations. CTorres ... View more

I assume that 3rd submatrix: 21 22 23 24 22 25 26 27 23 26 28 29 24 27 29 30 I also assume that table is a sas dataset: data table;   input v1-v4; cards; 3.201 0.104 7.66 -6.77 -2.09 6.14 2.54 -1.06 0.36 2.36 -1.05 1.8 0.89 -0.36 -1.25 -0.08 1.2     2.36 0.65 -0.19 0.44 -0.47 0.54 1.25 -0.04 1.78 -0.15 1.36 0.13 -0.54 1.23 1.11 ; run; I developed the following solution that creates 3 SAS datasets: Submatrix1, Submatrix2 and Submatrix3: data submatrix1(keep=colA:)      submatrix2(keep=colB:)      submatrix3(keep=colC:);   array vector(32);   array MatrixA(4,4);   array MatrixB(4,4);   array MatrixC(4,4);:   array ColA(4);   array ColB(4);   array ColC(4);   retain x 0;   do until (eof);      set table end=eof;      vector(x+1)=v1;      vector(x+2)=v2;      vector(x+3)=v3;      vector(x+4)=v4;      x+4;   end;   do i=1 to 4;      do j=1 to 4;         if min(i,j)=1 and (i=1 or j=1) then MatrixA(i,j)=max(i,j);         else if min(i,j)=2 and (i=2 or j=2) then MatrixA(i,j)=i+j+1;         else MatrixA(i,j)=i+j+2;      end;   end;   do i=1 to 4;      do j=1 to 4;         MatrixB(i,j)=MatrixA(i,j)+10;         MatrixC(i,j)=MatrixA(i,j)+20;      end;   end;   do i=1 to 4;      do j=1 to 4;         n=MatrixA(i,j);         colA(j)=vector(n);         n=MatrixB(i,j);         colB(j)=vector(n);         n=MatrixC(i,j);         colC(j)=vector(n);      end;      output submatrix1;      output submatrix2;      output submatrix3;   end; run; Is this what you need? ... View more

Try this: data test (drop=pm); set dir.sampler; by date id time; lastpm=pm; if last.time; run; ... View more

%let medate=30MAY2014; %let want=%sysfunc(intnx(month,"&medate"d,-12),yymmn4); The value of macrovariable &want is already text. data test;    char="&want";    num=&want; run; ... View more

Hi Ptrick, I agree with you about "use as little user written code as possible" in DI Implementations and I always try to adhere to it but in this specific simple case I decided that it was much more easy and straight forward to write this program and insert the code in a user written transformation to be able to deploy the job to the LSF scheduler in a different and independent flow so even if the main flow teminates "ugly" the program is able to report that situation. In this case I was not only interested in reporting the job status and performance but also some other relevant information for the aplication inserted by me in the log. Finnaly, the best practice says "little" but not "none". ... View more