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 |
What is the difference between match merge and one to one merge?
How do you connect the desktop application to metadata server? : sas-grid-administration
what are some differences between proc summary and proc means? : Sas programming
what is null hypothesis? why do you consider that?
0 Answers Accenture, Quintiles,
Difference b/n proc means and proc summary procedures?
What was the last computer book you purchased? Why?
In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)
8 Answers GSK GlaxoSmithKline,
what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter?
36 Answers Accenture, College School Exams Tests, CTS, IBM, IHRD, Infosys, Sylhet Engineering College, TCS, Wipro,
The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?
AE datasets names? how many types?
For what purpose would you use the RETAIN statement?
what is sas? is a package or tool? give me introduction about sas?