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 basic syntax of a sas program?

1263

---

How necessary is it to be creative in your work?

2525

---

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

1118

---

Differentiate between format and informat? : sas-grid-administration

1120

---

State the difference between INFORMAT and FORMAT ?

1151

---

What is a pdv and what are its functions?

1216

---

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1728

---

Give e an example of..

2382

---

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

1346

---

Explain why double trailing @@ is used in input statement?

1114

---

How you can read the variables that you need?

1177

---

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

1297

---

How to include or exclude specific variables in a data set?

1164

---

Which command is used to save logs in the external file?

1149

---

how can you put a "trace" in your program? : Sas programming

1111

---