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.

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

0 Answers  

---

What is the difference between %put and symbolgen? : sas-macro

0 Answers  

---

hi guys ...i have one query... data abc; input s w k g o t a m; cards; 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 9 ; run; i want the output to be the sorted order(only variables).observations should not be changed..

14 Answers  

---

What SAS statements would you code to read an external raw data file to a DATA step?

6 Answers   Accenture,

---

What is your favorite all time computer book? Why?

0 Answers   Oracle,

---

What is difference between Global n Local Macro Variables..?

6 Answers   TCS,

---

Baseline definition in your study

3 Answers   Accenture, Quintiles,

---

What are the uses of sas?

0 Answers  

---

Identify statements whose placement in the DATA step is critical.

6 Answers   Accenture, Labasol,

---

What is the difference between an informat and a format? Name three informats or formats.

13 Answers   Accenture, IBM,

---

How do i read multiple spaces in datasets?

4 Answers   Quintiles,

---

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.

9 Answers   Quintiles,

---