Can we replace a dataset into view?
- 6 Answers
- 11244 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 |
What is the difference between %put and symbolgen? : sas-macro
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
For clinical entire study how many tables will create approx?
How many tiers in sas architecture?
what is the difference between proc report and proc format?
I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...
How do dates work in SAS data?
Why and when do you use proc sql?
What is the difference between using drop = data set option in data statement and set statement?
"What is the difference between proc sort nodup and proc sort nodupkey?"
How do you download a flat file from Mainframe to your local PC using SAS?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
Teradata 
