LIBNAME for Stata

[Karoku_valentine]

Hi everyone,

 

I have a question for those of you who happen to use Stata and SAS. At my company, they requested a SAS license for me, but it is being delayed and I have to work with databases. Until now, the actuary normally downloads the databases for me and hands them using a USB. But this takes a lot of time; he told me that I should try to figure out if I can access those databases using Stata.

 

So, basically the command he uses to "directly connect to the server" is this:

 

Libname LAC ORACLE user='XXXXXX' password='XXXXXX' path='XXXX_exadata'  schema='GORAPR';

 

I was wondering if  could do something like this using Stata or even R, but mostly Stata, I am relatively new to R.

 

Greetings.

[StatsG0d]

Not sure if this will help or not.

http://www.ats.ucla.edu/stat/stata/faq/odbc.htm

[Karoku_valentine]

Thank you.