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;

Describe the function and untility of the most difficult SAS macro that you have written.

2165

---

Do you need to rearrange the order of the data for the report?

2268

---

Describe the function and untility of the most difficult SAS macro that you have written.

2065

---

what is sas olap server? : Sas-di

1213

---

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

1152

---

What are all the problems you faced while validating tables and reports?

3412

---

Which are the statements whose placement in the data step is critical?

1203

---

how do you debug and test your sas programs? : Sas programming

1087

---

Explain the difference between nodup and nodupkey options?

981

---

what has been your most common programming mistake? : Sas programming

1047

---

explain the key concept of sas? : Sas-administrator

954

---

how does sas handle missing values in functions? : Sas programming

1146

---

explain the concepts and capabilities of business object? : Sas-bi

923

---

What is the use of function Proc summary?

1231

---

What do you understand by the term Normal Distribution?

937

---