I need access Oracle from SAS.
1) Oracle database is in another server computer,
2) local computer has SAS, but no Oracle;
3) local computer use Windows7(64 byte).
4) Now I can access Oracle from Toad, but I need access from SAS!.
Do I need install Oracle on my local computer? Or just install ODBC driver? What's dsn mean in the code below?
Proc sql ;
connect to ODBC (dsn = 'XXXX' user = gzhang password = XXXX) ;
create table CTable as
select * from connection to ODBC
Can anyone help me, I will appreciate it.
No, you don't need Oracle installed locally, but you do need some method of your computer talking to Oracle.
Try following the instructions here:
What SAS product do you have to connect to Oracle?
SAS/ACCESS to ODBC, SAS?ACCESS to OLEDB or SAS/ACCESS to Oracle? One of these must be installed and licensed to connect to Oracle. You can check your licence by running: proc setinit noalias; run;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.