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.

how can you improve the performance of a query, If it is excuting very slowly?

2 Answers   Zensar,

---

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  

---

Can we create datasets by proc step ? (Proc contents, Means)?

2 Answers  

---

How could you generate test data with no input data?

14 Answers   CTS,

---

How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student.

4 Answers   TCS,

---

What sas features do you use to check errors and data validation?

0 Answers  

---

How would you delete duplicate observations?

10 Answers   Accenture,

---

What is LAG function?How is it used? can any one explain

3 Answers   TRE, Verinon Technology Solutions,

---

Name statements that function at both compile and execution time?

1 Answers  

---

How would you code the criteria to restrict the output to be produced?

6 Answers   Accenture,

---

how can you import .csv file in to sas? : Sas programming

0 Answers  

---

1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question

8 Answers   CitiGroup,

---