Interested to Buy Any Domain ? << Click Here >> for more details...
HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES?
WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
- 3 Answers
- 10002 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/Access and SAS/Connect?what are the uses?
how do u validate the program which u have written.
How would you include common or reuse code to be processed along with your statements?
What areas of SAS are you most interested in?
What do you know about symput and symget?
Explain the message 'Merge has one or more datasets with repeats of by variables'.
what are the component of range? : Sas-bi
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
why is sas data integration studio important? : Sas-di
What are the statements that are executed only?
Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.
in which companies SAS openings are there? List of companies using SAS technology.
Teradata 
