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

Describe the ways in which you can create a macro variable?

858


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

813


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

1875


Explain by-group processing?

808


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

1037


What are the difference between sas functions and procedures?

875


Describe a time when you were really stuck on a problem and how you solved it?

2333


how do you test for missing values? : Sas programming

814


What are the data types does SAS contain?

881


Have you ever used the SAS Debugger?

1494


What does the RUN statement do?

1095


What is maximum number of rows and cols can be handled in SAS?

1121


what does the run statement do? : Sas programming

813


Name some categories in sas 9? : sas-grid-administration

765


name some data transformation used in sas di? : Sas-di

758