How to extract the data from other databases(oracle,oracle clinical,.. 1

[YP20]

Hi ,

I am just learning SAS and trying to get idea for the above qn?
Could U give me the infirmation about extraction of data from other sources into sas datasets where I don't have any SAS/ACCESS product.

can U show me with example what r the possible options if possible?

Thanks,
Yp20.

 

[jymm]

Do you have the ODBC addon??? If so, accessing & updating databases is QUITE easy.

Ex - I use sqlserver - when I go against the DB I use

libname TechDB odbc
dsn=sqlserver DATASRC="Tech";

The DATASRC is what the ODBC connection is called on your the machine running the SAS job.

To access a table I simply say
data These;
set TechDB.SOP10200; /*pull the SOP table*/

updating, deleteing and appending are also quite easy... if you have the ODBC part.

 

[fyr]

I use Oracle here. so we use the following snipped of code:

proc sql stimer;
connect to oracle as mydb(user=username orapw=password path="path-to-db" preserve buffsize=1000);

create table lib.table as
select *
from connection to mydb

(ORACLE SQL QUERY);

disconnect from mydb;

 

[YP20]

Thanks for all, and it was quite helpful for me to go forward with data manipulations .



Thanks ,
YP20.