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..
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Give some examples where proc report’s defaults are same as proc print’s defaults?
explain the function of substr in sas? : Sas-administrator
Mention the category in which sas informats are placed?
How do dates work in sas?
What do the put and input function do?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
what has been your most common programming mistake? : Sas programming
which features do you use to check the data validations and errors? : Sas-administrator
explain the main difference between the nodup and nodupkey options? : Sas-administrator
how does sas handle missing values in assignment statements? : Sas programming
What is PDV?
what are informats in sas? : Sas-administrator
What is the general format of function in sas? : sas-grid-administration
What is the purpose of _character_ and _numeric_?
explain the proc in sas? : Sas-administrator