HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES?
WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
- 3 Answers
- 8859 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 is SAS Information Map Studio and its purpose ?
how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this should be displayed as field1 10 field2 20 field3 30 (without the obs col) how do this?can i use transpose or tell me suitable way to do this?
What do you know about symput and symget?
What report output formats can you generate using SAS?
what is the diff. b/w proc means and proc summary?
what is the primary variable in your study?
what is the difference between proc means and proc tabulate?
What is the one statement to set the criteria of data that can be coded in any step?
How would you delete duplicate observations?
Differences between where and if statement?
What is difference between sas rename and lable?
what is sas and what are the functions? : Sas-administrator
Teradata 
