Creating data set from specific columns in other data set iml

[newSAS2017]

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 · Accepted solution]

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]

Thank you that works really well!

[Kurt_Bremser]

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]

Thanks - will do