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 the difference between ceil and floor functions in sas?

954

---

explain what is factor analysis? : Sas-administrator

742

---

Have you ever used the SAS Debugger?

1393

---

what is the use of proc contents and proc print in sas? : Sas-administrator

770

---

What makes sas stand out to be the best over other data analytics tools?

741

---

---

How many data types are there in SAS?

766

---

what is sas application server? : Sas-di

660

---

What can be the size of largest dataset in SAS?

885

---

what is the difference between infile and input? : Sas-administrator

788

---

What does P-value signify about the statistical data?

1028

---

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

1960

---

What is SAS?

756

---

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

748

---

What function CATX syntax does?

825

---

how do you test for missing values? : Sas programming

720

---