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;

Are you sensitive to code walk-throughs peer review or QC review?

2594

---

What are the scrubbing procedures in sas?

567

---

what is the use of proc contents and proc print in sas? : Sas-administrator

599

---

What are the difference between sas functions and procedures?

634

---

Give some examples where proc report’s defaults are same as proc print’s defaults?

634

---

---

What commands are used in the case of including or excluding any specific variables in the data set?

583

---

What are the differences between proc means and proc summary?

597

---

What is the purpose of trailing @ and @@? How do you use them?

605

---

how do the in= variables improve the capability of a merge? : Sas programming

929

---

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

622

---

What is substr function?

618

---

what are some good sas programming practices for processing very large data sets? : Sas programming

507

---

Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1456

---

Give e an example of..

1838

---

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

593

---