Interested to Buy Any Domain ? << Click Here >> for more details...
Can we replace a dataset into view?
- 6 Answers
- 12195 Views
- CliniRx, I also Faced
- E-Mail Answers
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 |
Explain the difference between using drop = data set option in set and data statement?
what is TAB delimiter? explain about it? what will you do to get TAB delimiter?
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
List out some key concept of SAS
What is the difference between SAS functions and procedures?
What is the difference between %put and symbolgen? : sas-macro
I have a dataset concat having variable a b & c. How to rename a b to e & f?
how to delete the duplicates by using proc sql?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
"What is the difference between proc sort nodup and proc sort nodupkey?"
for whom is sas data integration studio designed? : Sas-di
Teradata 
