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.

i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.

6 Answers   CTS,

---

How many versions came upto now in SAS?

3 Answers   CTS, TCS,

---

For what purposes have you used sas macros? : sas-macro

1 Answers  

---

how can u join the two tables without using proc sql Joins and nested queries ?

6 Answers   IBM,

---

What is the difference between INPUT and INFILE ?

1 Answers  

---

IS SAS COMPILER OR INTERPRETER? EXPLAIN?

3 Answers   Aon Hewitt, HSBC, SCL, TCS,

---

I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,

---

Identify statements whose placement in the DATA step is critical.

6 Answers   Accenture, Labasol,

---

What is the function of output statement in a SAS Program?

1 Answers  

---

Did you used proc test? when?

1 Answers   Accenture, Quintiles,

---

why a stop statement is needed for the point= option on a set statement?

1 Answers  

---

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

1 Answers  

---