Answer / 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.

Answer / santosh

A> %let orapath (user=testuser password=testpass
buffsize=100
path='myorapath');
proc sql;

connect to oracle (&orapath);
select * from connection to oracle
(select * from <Table name>);
Where dept =’Sales’;
Disconnect from oracle
Quit;
Run;

Answer / shah

You can also use OLEDB, and ODBC database connectivity to
get data from Oracle.

what is the difference between proc means and proc summary?

2 Answers   Accenture,

---

how do you debug and test your sas programs? : Sas programming

0 Answers  

---

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

16 Answers  

---

What are types of transport files?

2 Answers   PRA Health Sciences, Quintiles,

---

I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak

1 Answers  

---

What are the new features included in the new version of SAS Programming Language?

0 Answers  

---

Differences between where and if statement?

0 Answers  

---

how do you read binary data in sas?

3 Answers   Satyam,

---

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

10 Answers   Accenture,

---

WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?

3 Answers   Accenture,

---

explain the difference between proc means and proc summary?

0 Answers  

---

How to read multiple excel sheets from a single excel file at once????

7 Answers   HCL, Verinon Technology Solutions,

---