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.

Where do you use proc means over proc freq?

1051

---

what is sas data set?

1056

---

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1849

---

What do you know about sas and what we do? : sas-grid-administration

1048

---

what is the difference between floor and ceil functions in sas? : Sas-administrator

1185

---

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1867

---

How can you create a macro variable with in data step? : sas-macro

982

---

explain the use of % includes a statement in sas? : Sas-administrator

942

---

what type of graphs we will create(for 2+years candidates)?

2238

---

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

997

---

What is the difference between order and group variable in proc report?

1362

---

How many ways to overcome a missing values???

2750

---

What do the mod and int function do? : Sas programming

1128

---

Describe 5 ways to do a “table lookup” in SAS?

1086

---

Are you sensitive to code walk-throughs peer review or QC review?

3092

---