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.

Explain the main difference between the sas procedures and functions? : Sas-administrator

1113

---

What are the different versions of sas that you have used until now? : sas-grid-administration

1389

---

what is the primary data source for the wrs? : Sas-bi

1333

---

What is the length assigned to the target variable by the scan function?

1205

---

What Proc glm does?

1138

---

What are the difference between ceil and floor functions in sas?

1400

---

is data integration and etl programming is same? : Sas-di

1125

---

how will you location sas platform applications available from web browser? : Sas-bi

1118

---

name several ways to achieve efficiency in your program? : Sas programming

1140

---

how does sas handle missing values in formats? : Sas programming

1190

---

what is the difference between unique key and primary key? : Sas-di

1176

---

what can you learn from the sas log when debugging? : Sas programming

1141

---

what has been your most common programming mistake? : Sas programming

1185

---

Difference between sum function and using “+” operator?

1207

---

How would you determine the number of missing or nonmissing values in computations?

1130

---