sas怎么样连接oracle

shiyiming

我装的是oracle的客户端，我想直接在sas中访问oracle里面的数据。另外怎么样才能查看我是否有安装了并可以使用SAS/ACCESS to Oracle?谢谢

shiyiming

1. To verify by submitting  [proc setinit; run;].  If you see below list,   it tells that SAS/ACC-ORACLE has been installed.i

---SAS/ACC-ORACLE        30SEP2007 (expiration date)


2.  To access Oracle

libname mydblib oracle user=MYID
   password=MYPWD path='my_db';

proc print data=mydblib.employees;
   where ID=:'Ch';   
run;

******* OR ***********;
proc sql;   
connect to oracle (user=MYID
                   password=MYPWD);   
select *      
   from connection to oracle         
     (select * from employees
      where id like 'Ch%');
    disconnect from oracle;
quit;

shiyiming

Thanks a lot !