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 would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
wt is a-z and a--z?
What does proc print, and proc contents are used for?
What is PDV?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
what is pdv? how it is related to input buffer in sas?
Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.
What is the difference between %local and %global?
How would you identify a macro variable? : sas-macro
Approximately what date is represented by the SAS date value of 730?
Describe the function and untility of the most difficult SAS macro that you have written.
How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO