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 ( select .... Can anyone help me, I will appreciate it.
... View more