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 techniques and/or procs do you use for tables? : Sas programming

1066

---

what is sas metadata repository? : Sas-bi

1119

---

Name any two sas spawners? : sas-grid-administration

1039

---

What is the difference between proportion and average?

3337

---

what is sas business intelligence? : Sas-bi

1183

---

What are the data types does SAS contain?

1117

---

What is the good sas programming practices for processing large data sets?

1119

---

What function CATX syntax does?

1224

---

Tell me about % include and % eval? : sas-macro

1144

---

Explain data step in SAS

1101

---

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2462

---

What is the basic structure of a sas program?

1122

---

How do you test for missing values?

1639

---

What does P-value signify about the statistical data?

1364

---

what is the use of sas management console? : Sas-di

1096

---