HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES?
WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
Answer Posted / chaitanya
Two ways that I know to retrieve data from oracle tables are
1. Libname Facility:
Example:
libname mydblib oracle user=testuser password=testpass path=hrdept_002;
proc print data=mydblib.employees;
where dept='CSR010';
run;
2. Passthrough Facility:
Example :
proc sql;
connect to oracle as dbcon
(user=testuser password=testpass buffsize=100
path='myorapath');
select *
from connection to dbcon
(select * from customers
where customer like '1%');
disconnect from oracle;
quit;
b. Oracle Clinical:
Oracle Clinical (OC) is the software package that is widely used in the pharmaceutical environment as a data entry
and storage tool. It captures the data entered from CRF (Case Report Form) and stores the data in its database
system.
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
how to generate the test data in sas without input data? : Sas-administrator
Tell e how how dealt with..
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
what is the purpose of _error_? : Sas programming
How do dates work in SAS data?
Give some ways by which you can define the variables to produce the summary report (using proc report)?
Describe a time when you were really stuck on a problem and how you solved it?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
what does the run statement do? : Sas programming
describe the interaction table in sas di? : Sas-di
What is the length assigned to the target variable by the scan function?
What do the put and input function do?
What are the differences between sum function and using “+” operator?
how are numeric and character missing values represented internally? : Sas programming
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro