topic Re: Need to fill up a matrix with character and numeric values in SAS/IML Software and Matrix Computations

Need to fill up a matrix with character and numeric values

azt5173 — Fri, 15 Jun 2018 16:25:39 GMT

I have two matrices [A ] and {1,2,3} basically I need to combine the matrix that looks like {A1 A2 A3.

B B1 B2 B3

[C] C1 C2 C3}

The first matrix is for treatments(A,B,C) and the second matrix is for the age factor(1,2,3).

The resulting matrix will be used to check for imbalance between the treatments and age factor.

I used the code below where basically tired to merge the two matrices:

proc iml;
M1={A,
B,
C};
M2={1 2 3};
nNames="B1":"B3";
cNames="A1":"A3";
create ndat from M1[colname=nNames];
append from M1;
create cdat from M2[colname=cNames];
append from M2;
quit;
data dat;
merge ndat cdat;
run;

This didn't really work as I still need to form a combination of two matrices. Any help will be appreciated. Thank you.

Need to fill up a matrix with character and numeric values

azt5173 — Fri, 15 Jun 2018 15:55:08 GMT

I have two matrices [A ] and {1,2,3} basically I need to combine the matrix that looks like {A1 A2 A3.

B B1 B2 B3

[C] C1 C2 C3}

The first matrix is for treatments(A,B,C) and the second matrix is for the age factor(1,2,3).

The resulting matrix will be used to check for imbalance between the treatments and age factor.

I used the code below where basically tired to merge the two matrices:

This didn't really work as I still need to form a combination of two matrices. Any help will be appreciated. Thank you.

Re: Need to fill up a matrix with character and numeric values

Cynthia_sas — Fri, 15 Jun 2018 16:22:10 GMT

Hi:
You'll probably get more answers if you post this in the forum for IML questions:
https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/bd-p/sas_iml

Cynthia

Re: Need to fill up a matrix with character and numeric values

Rick_SAS — Fri, 15 Jun 2018 17:16:52 GMT

Try this:

M1={A,B,C};
M2={1 2 3};
xy = expandgrid(M1, char(M2) ); /* 2 columns */
G = rowcatc(xy);   /* concatenate and get rid of blanks */
M = shape(G, nrow(M1)); /* shape into matrix */

nNames="B1":"B3";
cNames="A1":"A3";
print M[r=nNames c=cNames];

Re: Need to fill up a matrix with character and numeric values

Ksharp — Sat, 16 Jun 2018 11:03:33 GMT

proc iml;
M1={A,
B,
C};
M2={1 2 3};
want=cats(repeat(m1,1,3),repeat(m2,3,1));
print want;
quit;