BookmarkSubscribeRSS Feed
4 REPLIES 4
juandihb
Fluorite | Level 6
I need to establish an ODBC connection but there is no available connection from Rstudio to do it
Tom
Super User Tom
Super User

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.

 

juandihb
Fluorite | Level 6

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

SASKiwi
PROC Star

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&docse...

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 4732 views
  • 0 likes
  • 3 in conversation