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
What do you understand by the term Normal Distribution?
What are the parameters of scan function?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
Can you suggest us materials for sdtm mapping?
How many data types are there in SAS?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
To what type of programms have you used scratch macros?
Explain the special input delimiters used in sas programming.
How would you identify a macro variable?
How do you specify the number of iterations and specific condition within a single do loop?
: and & modifiers.
Describe the ways in which you can create a macro variable?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
why is sas considered self-documenting? : Sas programming
What is the function of Stop statement in a SAS Program?