topic Re: Merge both character matrix and numeric Matrix in SAS/IML Software and Matrix Computations

Merge both character matrix and numeric Matrix

thepushkarsingh — Fri, 15 Feb 2019 11:50:18 GMT

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.

Re: Merge both character matrix and numeric Matrix

andreas_lds — Fri, 15 Feb 2019 12:33:29 GMT

@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.

Re: Merge both character matrix and numeric Matrix

thepushkarsingh — Fri, 15 Feb 2019 12:44:20 GMT

Thanks. I'll use a data merge then.

Re: Merge both character matrix and numeric Matrix

Rick_SAS — Fri, 15 Feb 2019 22:03:14 GMT

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;

Re: Merge both character matrix and numeric Matrix

Ksharp — Sat, 16 Feb 2019 13:19:43 GMT

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;