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.
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];
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.
proc iml;
M1={A,
B,
C};
M2={1 2 3};
want=cats(repeat(m1,1,3),repeat(m2,3,1));
print want;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.