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.

What are symget and symput? : sas-macro

1303

---

How does proc sql work?

1069

---

State the difference between INFORMAT and FORMAT ?

1093

---

Can you execute a macro within a macro? Describe. : sas-macro

1103

---

What is the function of output statement in a SAS Program?

1060

---

why a stop statement is needed for the point= option on a set statement?

1059

---

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2098

---

What is the function of Stop statement in a SAS Program?

1143

---

What is SAS? What are the functions does it performs?

1190

---

What are the features of base sas system?

1057

---

What is substr function?

1174

---

Tell e how how dealt with..

2218

---

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4505

---

what is change analysis in sas di ? : Sas-di

1053

---

describe about physical data integration? : Sas-di

1040

---