Interested to Buy Any Domain ? << Click Here >> for more details...
Can we replace a dataset into view?
- 6 Answers
- 12703 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 nodup and nodupkey options?
20 Answers iFlex, Makro, Talwar,
What is the one statement to set the criteria of data that can be coded in any step?
what is the use of proc contents and proc print in sas? : Sas-administrator
What does the RUN statement do?
who is the best SAS clinical Trainer in Hyderabad?
What is Linear Regression?
i want to upload titles and footnotes to excel file?how it is possible?
How will you generate test data with no input data?
Mention the validation tools used in SAS?
describe about metadata object? : Sas-di
The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
Name statements that are recognized at compile time only?
Teradata 
