topic Re: PROC IML - importing data from R in SAS/IML Software and Matrix Computations

PROC IML - importing data from R

alix1 — Mon, 27 Aug 2018 02:03:46 GMT

Hello,

I want to obtain x as a two column array, the first column must be a vector of values one and the other xi is a variable of decimal values that comes from the database imported from R, au_obsbipoiss. I am doing it in the following way

proc iml;
reset noname;
use distrib.au_obsbipoiss;
read all var{y_1} into y1;
read all var{y_2} into y2;
read all var{xmat} into xi;
r = nrow(y1);
x= J(r, 1, 1)||xi;

However, SAS takes xi as a character variable so I can not get x.
What I can do? please help me.

Re: PROC IML - importing data from R

Rick_SAS — Mon, 27 Aug 2018 10:52:31 GMT

The best thing is for you to get the database to use numbers instead of character values. If you can't do that, then use the NUM function to convert the character values to numeric:

x= J(r, 1, 1) || num(xi);

Re: PROC IML - importing data from R

alix1 — Mon, 27 Aug 2018 20:53:22 GMT

thanks, but it did not work

Re: PROC IML - importing data from R

Rick_SAS — Fri, 31 Aug 2018 12:51:03 GMT

If you expect help, you need to provide more information. What didn't work? What does the log say? Can you provide sample data?

Here is an example that demonstrates the technique that I suggested:

proc iml;
xi = {'1', '2', '3.14159', '-2.7'};
r = nrow(xi);
x= J(r, 1, 1) || num(xi);
print x;