Answer Posted / sriraghubabu

yes, we can replace dataset into view in Proc sql.
example:

proc sql;
create view newemp as
select *
from Employee
group by name;
select * from newemp;
quit;

now the data set is replaced into view..

what does the run statement do? : Sas programming

1002

---

Explain substr function?

1044

---

What are the special input delimiters used in SAS?

1114

---

Explain what is SAS informats?

1051

---

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

1025

---

What is a macro routine?

2654

---

Mention the category in which sas informats are placed?

984

---

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

1250

---

Explain the purpose of retain statement.

1014

---

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2194

---

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

1033

---

How would you invoke a macro? : sas-macro

1050

---

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1110

---

What is the SAS data set?

1094

---

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

1063

---