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.

This entry was posted in General. Bookmark the permalink. Post a comment or leave

0 Answers   Quintiles,

---

Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..

1 Answers  

---

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

0 Answers  

---

Have you used macros? For what purpose you have used? : sas-macro

0 Answers  

---

what are different type of sas servers ? On which server does the sas code execute ?

4 Answers   TCS,

---

Mention what is PROC in SAS?

0 Answers  

---

how to read the variables in sas? : Sas-administrator

0 Answers  

---

What are the scrubbing procedures in sas?

0 Answers  

---

For what purpose would you use the RETAIN statement?

0 Answers   Quintiles,

---

here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.

2 Answers   Cap Gemini, L&T,

---

what is the difference btw proc means and proc univariate?

8 Answers   HSBC, TCS,

---

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

0 Answers  

---