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 to read character value without using substr function in sas ?
for whom is sas data integration studio designed? : Sas-di
Does anybody has lastest SAS certification dumps,if anybody has please mail me on saggydesai@gmail.com
What do you understand by the term Normal Distribution?
Name validation tools used in SAS
How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
What is the basic syntax style in SAS?
Name statements that function at both compile and execution time?
how we can call macros with in data step?
What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.
Why do we use QUIT commmand for proc datasets and proc sql ???
Name and describe few sas character functions that are used for data cleaning in brief.