topic How to select a column by its name in PROC IML process? in SAS Programming

How to select a column by its name in PROC IML process?

BingL — Tue, 26 Jan 2016 09:59:30 GMT

Hello to whomever can help

I have a data set like following:

I tried the following program, but it give me error.

PROC IML;
        print (mu_vec['MSFT']);

error message is like following. Please help. Thank you.

Re: How to select a column by its name in PROC IML process?

Rick_SAS — Tue, 26 Jan 2016 18:53:25 GMT

First you have to read the data from the data set into a matrix or vector.

Read the article "Reading ALL variables INTO a matrix."

Is the data in a data set that has one observation and three variables? If so, then the PROC IML statements look like this:

proc iml;
use Have;
read all var {"MSFT" "NORD" "SBUX"} into mu_vec;
close Have;

If you want to read all of the numeric variables, you can use this:

read all var _NUM_ into mu_vec[colname=varNames];

Re: How to select a column by its name in PROC IML process?

BingL — Tue, 26 Jan 2016 19:02:35 GMT

Hello Rick

Thank you for your response and help.

Data was create in PROC IML procedure.

It is like following code:

names = {'MSFT' 'NORD' 'SBUX'};
mattrib mu_vec c=names;

actually I haven't tried the following.

mu_vec[, 'MSFT'];

Re: How to select a column by its name in PROC IML process?

Rick_SAS — Tue, 26 Jan 2016 19:09:38 GMT

If you are using a column name attribute, you need to specify the name as a column:
mu_vec[, 'MSFT'];

For more information and examples, see "Access rows or columns of a matrix by names."