HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES?
WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
- 3 Answers
- 9265 Views
- Accenture, Novartis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / santosh
A> %let orapath (user=testuser password=testpass
buffsize=100
path='myorapath');
proc sql;
connect to oracle (&orapath);
select * from connection to oracle
(select * from <Table name>);
Where dept =’Sales’;
Disconnect from oracle
Quit;
Run;
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / shah
You can also use OLEDB, and ODBC database connectivity to
get data from Oracle.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the sites did u refer for enquiries and doubts for SAS
where to use sas business intelligence? : Sas-bi
how we can create optional or required parameters in SAS macro...
What is the sas data set? : sas-grid-administration
What are the data types does SAS contain?
Identify statements whose placement in the DATA step is critical?
State the difference between INFORMAT and FORMAT ?
What are the limitations for memory allocation for SAS variables
how could you generate test data with no input data? : Sas programming
What are the new features included in the new version of SAS Programming Language?
What is the role of administrative users? : sas-grid-administration
what is the use of catalog?
Teradata 
