topic Creating data set from specific columns in other data set iml in SAS/IML Software and Matrix Computations

Creating data set from specific columns in other data set iml

newSAS2017 — Thu, 09 Mar 2017 14:22:24 GMT

I have a data set with a number of columns. I am wanting to create a data set from this using a selection of the columns:

In iml

Instead of

use = old_use[1:100, 1:75];

I want to have

use = old_use[1:100, 1:50] + old_use[1:100, 53:57] + old_use[1:100, 59:75];

But it is not returning the correct number of columns....

Rick_SAS — Thu, 09 Mar 2017 14:47:25 GMT

The addition operator is trying to add matrices that do not have the same number of columns. Perhaps you mean to use the concatenation operator:

use = old_use[1:100, 1:50] || old_use[1:100, 53:57] || old_use[1:100, 59:75];

If so, a more efficient method is to form a vector of the column indices and then do a single extraction:

cols = (1:50) || (53:57) || (59:75);

use = old_use[1:100, cols];

newSAS2017 — Thu, 09 Mar 2017 15:14:16 GMT

Thank you that works really well!

Kurt_Bremser — Thu, 09 Mar 2017 15:24:15 GMT

When posting questions, look if there's a suitable community. My moving of your post to the IML community probably triggered @Rick_SAS's attention.

newSAS2017 — Thu, 09 Mar 2017 15:25:25 GMT

Thanks - will do