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 |
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
how to remove duplicates using proc sql?
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
what is conditional processing?
i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?
How do you delete duplicate observations in sas?
How do i read multiple spaces in datasets?
What r all the reporting procedures...?
how to import XTP files into SAS datasets?
1 Answers Barclays, Institute For Plasma Research,
sas macros
I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,