The following little program assigns column names to a row vector mu_vec. However, if this processing is carried out within a function, then the command "return(mu_vec);" will get rid of the column names. Is there a way to preserve these column names?
assetNames={"MSFT" "NORD" "SBUX"};
mu_vec={0.042 0.0015 0.028};
mattrib mu_vec c=assetNames;
print mu_vec;
I assume that you are trying something like the following:
start Func(x);
assetNames={"MSFT" "NORD" "SBUX"};
mu_vec={0.042 0.0015 0.028};
mattrib mu_vec c=assetNames;
return mu_vec;
finish;
y = Func(x); /* copies values but not atrtributes */
print y;
This doesn't work the way you hoped because inside the FUNC module, the variable X is a local variable. Any attributes you assign as assigned to the local variable and are not copied to the variable Y, which has a different scope. (See this article to learn more about the scope of variables in the SAS/IML language.)
If you want to give Y attributes, you need to assign them in the scope for Y. If the column names are known inside the function, you can return them (as part of a list) from the function. You can then call the MATTRIB statement in the parent environment. like this:
start Func2(x);
assetNames={"MSFT" "NORD" "SBUX"};
mu_vec={0.042 0.0015 0.028};
return ( [mu_vec, assetNames] ); /* return a list */
finish;
L = Func2(x); /* output is a list with two items */
y = L$1; /* values are the first item in list */
mattrib y c=(L$2); /* column names are the second item */
print y;
I assume that you are trying something like the following:
start Func(x);
assetNames={"MSFT" "NORD" "SBUX"};
mu_vec={0.042 0.0015 0.028};
mattrib mu_vec c=assetNames;
return mu_vec;
finish;
y = Func(x); /* copies values but not atrtributes */
print y;
This doesn't work the way you hoped because inside the FUNC module, the variable X is a local variable. Any attributes you assign as assigned to the local variable and are not copied to the variable Y, which has a different scope. (See this article to learn more about the scope of variables in the SAS/IML language.)
If you want to give Y attributes, you need to assign them in the scope for Y. If the column names are known inside the function, you can return them (as part of a list) from the function. You can then call the MATTRIB statement in the parent environment. like this:
start Func2(x);
assetNames={"MSFT" "NORD" "SBUX"};
mu_vec={0.042 0.0015 0.028};
return ( [mu_vec, assetNames] ); /* return a list */
finish;
L = Func2(x); /* output is a list with two items */
y = L$1; /* values are the first item in list */
mattrib y c=(L$2); /* column names are the second item */
print y;
For an introduction to lists, see "Lists: Nonmatrix data structures in SAS/IML"
For an introduction to the list notational syntax, see "Create lists by using a natural syntax in SAS/IML"
Dr. Rick has said very clear.
Or could pass local matrix into global matrix ,if your IML is low version.
proc iml;
start Func(x) global(mu ,asset );
assetNames={"MSFT" "NORD" "SBUX"};
mu_vec={0.042 0.0015 0.028};
mattrib mu_vec c=assetNames;
mu=mu_vec ;asset=assetNames;
return mu_vec;
finish;
y = Func(x); /* copies values but not atrtributes */
mattrib mu c=asset l='';
print y , mu ;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.