Can we replace a dataset into view?
Answers were Sorted based on User's Feedback
Answer / jyotshna
yes we can replace dataset into view
syntax:
data librefname.datasetname/view=librefnmae.datasetname;
run;
sample:
data aa/view=aa;
set sashel.class;
run;
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / vivek
proc sql;
create view <viewname> as
select *
from <Datasetname>;
quit;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gk
yes we can replace a data set with view by a procedure
called datasets
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
Answer / guest
yes we can
ex: data aa/view=bb;
input variables;
datalines;
run;
| Is This Answer Correct ? | 0 Yes | 3 No |
How do you define proc in sas? : sas-grid-administration
Tell me more about the parameters in macro? : sas-macro
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
How can you create a macro variable with in data step? : sas-macro
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
Baseline definition in your study
3 Answers Accenture, Quintiles,
What will calendar procedure do?
What is the use of %include statement?
How would you identify a macro variable?
what is function of retain statment
What is the difference between match merge and one to one merge?
I have a dataset with variables empid and doj how to calculate retirement age?