Merge both character matrix and numeric Matrix

[thepushkarsingh]

I have a data with Char ID and I am separating that ID from other vars(numerical) in a matrix. After all calculations I just want to merge them back(horizontal concatenation) for the output:

(UID is CHAR, EMI is NUM)

INFO=UID||EMI;

But IML is not allowing me:

ERROR: All specified variables must be the same type.

Any idea if and how it can be done?

Thanks a lot in advance.

[andreas_lds · Accepted solution]

---

@thepushkarsingh wrote:

I have a data with Char ID and I am separating that ID from other vars(numerical) in a matrix. After all calculations I just want to merge them back(horizontal concatenation) for the output:

(UID is CHAR, EMI is NUM)

INFO=UID||EMI;

But IML is not allowing me:

ERROR: All specified variables must be the same type.

Any idea if and how it can be done?

Thanks a lot in advance.

---

Afaik this can't be done while in proc iml.

[thepushkarsingh]

Thanks. I'll use a data merge then.

[Rick_SAS]

Yes, you can do it. Use the ROWNAME= option when you write the numerical matrix:

proc iml;
EMI = {1 2 3,
       4 5 6,
       7 8 9};
UID = {"A", "B", "C"};

create Want from EMI[rowname=UID];
append from EMI[rowname=UID];
close;
quit;

proc print data=Want;
run;

[Ksharp]

You can do it if you only want get a table .

proc iml;
use sashelp.class;
read all var {name age};
close;
age=age#100;

create want var {name age};
append;
close;
quit;

proc print;run;