HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES?
WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
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 |
How would you delete duplicate observations?
how the sas basic syntax style described? : Sas-administrator
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What is SAS?
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.
What are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
what is sas? is a package or tool? give me introduction about sas?
How do you download a flat file from Mainframe to your local PC using SAS?
name few built in sas transformation in DI studio ?
diff between nodup rec and ondup key???
what are 5 ways to perform a table lookup in sas? : Sas-administrator
how to change the execute of macro