Can we replace a dataset into view?

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


Please Help Members By Posting Answers For Below Questions

how do you debug and test your sas programs? : Sas programming

848


Explain what Proc glm does?

841


How to create an external dataset with sas code?

806


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1530


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1106


If a variable contains only numbers, can it be a character data type?

855


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

721


What are the difference between ceil and floor functions in sas?

1070


how to debug and test the sas program? : Sas-administrator

789


what is the effect of the options statement errors=1? : Sas programming

822


explain what is factor analysis? : Sas-administrator

841


What is run-group processing?

874


how could you generate test data with no input data? : Sas programming

895


What is the role of administrative users? : sas-grid-administration

875


List out some key concept of SAS

825