×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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.

 

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

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.

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

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;

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

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



Thanks ,
YP20.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close