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 chi-square test? have you used that?
1 Answers Accenture, Quintiles,
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
Name statements that are execution only.
Mention few capabilities of sas framework.
What are the uses of sas?
Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.
What is substr function?
what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;
Why is a STOP statement needed for the point=option on a SET statement?
What is the difference between order and group variable in proc report?
how do you test for missing values? : Sas programming