Answer Posted / 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;

what is the purpose of _error_? : Sas programming

872

---

for what purpose would you use the retain statement? : Sas programming

829

---

how to do user inputs and command line arguments in sas?

2692

---

what are some differences between proc summary and proc means? : Sas programming

775

---

How to convert a numeric variable to a character variable?

888

---

Tell me more about the parameters in macro? : sas-macro

831

---

Describe 5 ways to do a “table lookup” in SAS?

892

---

What do you code to create a macro? : sas-macro

829

---

How we can call macros with in data step? : sas-macro

847

---

What is the difference between match merge and one to one merge?

933

---

I have a dataset concat having variable a b & c. How to rename a b to e & f?

809

---

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

903

---

what do the pad and dim functions do? : Sas programming

796

---

How is character variable converted into numeric variable and vice versa?

894

---

What does the trace option do?

888

---