SAS中文论坛

标题: sas怎么样连接oracle [打印本页]

作者: shiyiming 时间: 2006-4-28 20:57
标题: sas怎么样连接oracle
我装的是oracle的客户端，我想直接在sas中访问oracle里面的数据。另外怎么样才能查看我是否有安装了并可以使用SAS/ACCESS to Oracle?谢谢

作者: shiyiming 时间: 2006-4-29 02:28
标题: RE:sas怎么样连接oracle
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 时间: 2006-4-30 17:39
标题: thanks
Thanks a lot !

欢迎光临 SAS中文论坛 (http://mysas.net/forum/)