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 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,
What’s the difference between var b1 – b3 and var b1 — b3?
what is star schema? : Sas-di
How to convert HTML file into SAS dataset?
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
explain what is factor analysis? : Sas-administrator
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
What is the difference between using drop = data set option in data statement and set statement?
What are the statements that are executed only?
how to rearrange the data as our wish by using dataset block?
how can u convert this 25-jul-2010 from numeric to charcter?