topic Re: SAS , R and Anaconda in SAS/IML Software and Matrix Computations

SAS , R and Anaconda

ODENWALD — Tue, 25 Jul 2017 07:28:14 GMT

Hi :

Anaconda is a highly rated distribution in the world of Data Science and Python. You can install and run R and R Studio side by side with Python.

Question : Could anyone access R in path C:\Users\Username\Anaconda3\R from SAS/IML (there is no further subfolder for R-version) ? Although R and R Studio are running without problems there appear error messages to the effect that no R is found.

Would appreciate some comments.

Odenwald

Re: SAS , R and Anaconda

Rick_SAS — Tue, 25 Jul 2017 09:45:49 GMT

Define the environment variable R_HOME. If the variable exists, SAS/IML will load R from the specified directory.

Note that the environment variable R_HOME must point to the root directory of the R installation and not to the "bin" subdirectory.

Re: SAS , R and Anaconda

ODENWALD — Tue, 25 Jul 2017 10:15:43 GMT

Rick : I did so (before).

From SAS Log ::

RLANG Enables SAS to execute R language statements.

ERROR: SAS could not initialize the R language interface.
ERROR: An installed version of R could not be found.
NOTE: env:R_HOME="C:\Users\Username\Anaconda3\R"
NOTE: DLL:"C:\Users\Username\Anaconda3\R\bin\x64\R.dll"

Both NOTEs are from SAS (pasted out of SAS log).

So SAS has grabbed the right locations.

My guess is that before get going there is read some kind of ini-type information that does not match.

Might be the version number of R out of the (standard) R-version subfolder that does not exist here.

Odenwald

Re: SAS , R and Anaconda

Rick_SAS — Tue, 25 Jul 2017 12:50:04 GMT

OK. I've never used Anaconda. It's possible that the directory structure is different from the CRAN standard. Officially, the CRAN installation is the only configuration that SAS supports, but I will ask around to see if anyone has experience with using the version of R that is distributed with Anaconda.

Software is not usually installed in a user's profile. Was "C:\Users\Username\Anaconda3" the suggested location for the install, or did you override the default?

I assume that you are running a 64-bit version of SAS on the same desktop PC?

Re: SAS , R and Anaconda

Reeza — Tue, 25 Jul 2017 13:24:49 GMT

Anaconda is an IDE for Python. For R, I thought it used RStudio, an IDE for R. You need to point SAS to your actual R installation. It's usually in its own folder under Programs. I can double check my set up when I get into the office later.

Re: SAS , R and Anaconda

ODENWALD — Tue, 25 Jul 2017 14:00:24 GMT

Rick :

I assume that you are running a 64-bit version of SAS on the same desktop PC? :: YES.

Software is not usually installed in a user's profile. Was "C:\Users\Username\Anaconda3" the suggested location for the install, or did you override the default? :: This was suggested by the Anaconda Installer and accepted.

Re: SAS , R and Anaconda

ODENWALD — Tue, 25 Jul 2017 14:05:19 GMT

Reeza :

At present R and the R dll are at these places, not in C:\Programs , but running fine ::

NOTE: env:R_HOME="C:\Users\Username\Anaconda3\R"
NOTE: DLL:"C:\Users\Username\Anaconda3\R\bin\x64\R.dll"

Because of the huge bulk I wanted to avoid a doubled installation, say on C: and on G:

Odenwald

Re: SAS , R and Anaconda

Reeza — Tue, 25 Jul 2017 14:55:33 GMT

I'm assuming you're installing under 'username' because you don't have admin privileges on your computer? If so, are you sure the environmental variables exist.

Anyways, I don't have R installed in the Anaconda folder at all, it's under C:\Programs, Python is installed in the Anaconda folder.

Re: SAS , R and Anaconda

ODENWALD — Tue, 25 Jul 2017 16:12:52 GMT

Reeza :

I chose this location because it was suggested by the Anaconda Installer and I accepted. I guess the reason is to make the whole handling more hassle-free (remove troubles when Install as Admin was forgotten or users don't have Admin rights).

I checked and SAS as well as Windows see the R_HOME exactly where it physically resides.

Odenwald

Re: SAS , R and Anaconda

Reeza — Tue, 25 Jul 2017 16:15:01 GMT

Then perhaps post your full SAS code that generate the error. Maybe there's a mistake in there somewhere. All we've seen so far is the errors.

Re: SAS , R and Anaconda

Reeza — Tue, 25 Jul 2017 16:21:57 GMT

Did you add the RLANG option to your Config file or invocation?

Re: SAS , R and Anaconda

ODENWALD — Tue, 25 Jul 2017 16:34:17 GMT

Reeza :

I start with SAS -- R . All parts have been checked and work.

Windows Environment variable R_HOME is correctly set.

proc options option= RLANG ; run ;

options set=R_HOME='C:\Users\Username\Anaconda3\R' ;

%put %sysget(R_HOME) ;

filename envcmd pipe 'set' lrecl=1024;
data WORK.Win10_Env_set;
infile envcmd dlm='=' missover;
length name $ 32 value $ 1024;
input name $ value $;
run;

/* If you get a matrix 14, 32, 50 as the result, then it's OK */

proc iml;
submit/R;
rx <- matrix( 1:3, nrow=1)
rm <- matrix( 1:9, nrow=3, byrow=TRUE)
rq <- rm %*% t(rx)
print(rq)
endsubmit;
quit;

proc iml;
/* Comparison of matrix operations in IML and R */
print "---------- SAS/IML Results -----------------";
x = 1:3;                                 /* vector of sequence 1,2,3 */
m = {1 2 3, 4 5 6, 7 8 9};               /* 3 x 3 matrix */
q = m * t(x);                            /* matrix multiplication */
print q;

print "------------- R Results --------------------";
submit / R;
rx <- matrix( 1:3, nrow=1)             # vector of sequence 1,2,3
rm <- matrix( 1:9, nrow=3, byrow=TRUE) # 3 x 3 matrix
rq <- rm %*% t(rx)                     # matrix multiplication
print(rq)
endsubmit;

Re: SAS , R and Anaconda

ODENWALD — Tue, 25 Jul 2017 16:38:36 GMT

Reeza :

Did you add the RLANG option to your Config file or invocation? :: YES .

Being confirmed by : proc options option= RLANG ; run ;

Odenwald

Re: SAS , R and Anaconda

Reeza — Tue, 25 Jul 2017 16:40:36 GMT

@ODENWALD wrote:

Reeza :

Did you add the RLANG option to your Config file or invocation? :: YES .

Being confirmed by : proc options option= RLANG ; run ;

Odenwald

I guess I'll take your word for it. Note that I didn't have to set the R_HOME settings, in fact it didn't work when I directed it to the R folder. If I put the path including the version it does work.

I DIDN'T DO THIS AND IT WORKED.

options set=R_HOME='C:\Program Files\R\' ;

%put %sysget(R_HOME) ;

I DID DO THIS AND IT WORKED:

options set=R_HOME='C:\Program Files\R\R-3.3.2' ;

%put %sysget(R_HOME) ;

Re: SAS , R and Anaconda

Tom — Tue, 25 Jul 2017 16:45:47 GMT

Looks to me like to get Anaconda to work you need to set the same environment variable R_HOME as SAS needs to work.

http://www.swegler.com/becky/blog/2014/08/03/ipython-ipython-notebook-anaconda-and-r-rpy2/

Re: SAS , R and Anaconda

ODENWALD — Tue, 25 Jul 2017 16:59:18 GMT

You have two folders and I (thanks to Anaconda) have one. The starting of SAS/IML to R seems to be internally programmed as to requiring two folders may be even the second one containing a version number of R.

Is this correct ?

If so I see 3 ways :

1. To convince SAS to work in the one-folder scenario, too.

2. To convince Anaconda to go to a two-folder scenario.

3. To make a second R-installation on my PC just for SAS --> R.

Would you agree ? Or do you see a 4.th option ?

Odenwald

Re: SAS , R and Anaconda

Reeza — Tue, 25 Jul 2017 17:06:23 GMT

I would add the version to the R folder - this seems to be standard, not sure why Anaconda dropped the version number, update the R_HOME and I would expect both SAS and Anaconda to work at that point. I think Anaconda also works off R_HOME.

Re: SAS , R and Anaconda

Reeza — Tue, 25 Jul 2017 17:25:33 GMT

Note that Anaconda has no issues working with the 'two folder' structure and having R located in the Program Files folder.

Re: SAS , R and Anaconda

Rick_SAS — Tue, 25 Jul 2017 19:41:08 GMT

My colleague installed Anaconda this afternoon and got SAS/IML to work with it. Here's what he did:

Installed Anaconda 4.4.0 for Windows 64.
Used the Anaconda Navigator to install RStudio 1.0.136.
By looking at the installation directory, it looks like RStudio uses a customized and extended version of R, which is installed in C:\Users\USERNAME\AppData\Local\Continuum\Anaconda3\R
In addition to the Anaconda3\R directory, the directory contains an Anaconda3\Library\mingw-w64\bin directory that includes extra files and DLLs. For example, the file zlib1.dll lives in this directory; I include that name because it is at the bottom of an alphabetical listing.

Here is what my colleague did to get SAS to work:

Add the DLL directory to the Windows PATH environment variable. You can do this through Window Control Panel: System and Security, System, Advanced system settings, Environment Variables. Click PATH and Edit button.
Set R_HOME to be the Anaconda3\R directory. You can do this through Window Control Panel (as above) or from the SAS command line:
-SET R_HOME "C:\Users\USERNAME\AppData\Local\Continuum\Anaconda3\R"

Appending the DLL directory to the PATH environment variable seems to be the step that most people would not know to do. Do Steps (1) and (2) before launching SAS

Disclaimer: we did this on one machine. We did not test the installation extensively. This is not a version of R that SAS officially supports.

I hope this information will be useful to someone. Your installation directories might vary.