topic Re: How to connect to SASapp from Rstudio in New SAS User

How to connect to SASapp from Rstudio

juandihb — Fri, 23 Nov 2018 15:49:14 GMT

Re: How to connect to SASapp from Rstudio

juandihb — Fri, 23 Nov 2018 15:51:07 GMT

I need to establish an ODBC connection but there is no available connection from Rstudio to do it

Re: How to connect to SASapp from Rstudio

Tom — Fri, 23 Nov 2018 16:00:39 GMT

If you want to connect to a SAS session and submit code and retrieve results then ODBC is not what you want. But if you are just trying to read SAS data in R then you can use haven package and do not need to connect to SAS itself.

Re: How to connect to SASapp from Rstudio

juandihb — Fri, 23 Nov 2018 16:07:13 GMT

Hello tom,

No, any of those is what I want. I have my MIS in SASApp, like in SAS I want to establish a connection to the SAS database, but when I go to Rstudio there is no an existing ODBC driver for SAS. Do I need to install a driver for these or how do I establish the connection to the database from Rstudio

Re: How to connect to SASapp from Rstudio

SASKiwi — Sat, 24 Nov 2018 00:25:11 GMT

I guess you mean this: https://www.rstudio.com/

If you are wanting help with connecting RStudio with other products then you would be best to post on an RStudio forum.

In general if you want to connect to a remote SAS server using ODBC then you need SAS/Share running on that server along with the SAS ODBC drivers. This link should help: https://documentation.sas.com/?docsetId=odbcdref&docsetTarget=p0cpyxc20b5ybin1o5sretxxv6au.htm&docsetVersion=9.4&locale=en