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

[BingL]

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.

[Rick_SAS]

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];

[BingL]

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'];

[Rick_SAS · Accepted solution]

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