what is the difference between SET and MERGE?
Answer Posted / sweety
Set : only support data without relation, with relation i.e
by statement it will produce error if we right like merge
statement.
Ex :
Set statement
data demo;
set dm1;
set dm2;
run;
It will produce the result same as merge , with or without
relation.
EX : data demo;
set dm1 dm2;
run;
It will produce error.
Merge : it will combine the datasets with or without
relation.
The only difference is set is not more efficient to combine
the datasets as we need to write set statement everytime.
Ex :
Merge (without relation)
data demo;
merge dm1 dm2;
run;
Merge (with relation)
data demo;
merge dm1 dm2;
by <variable name>
run;
Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Explain the use of proc print and proc contents?
What is the maximum and minimum length of macro variable
how many display types available in sas bi dashboard? : Sas-bi
what are informats in sas? : Sas-administrator
how to do user inputs and command line arguments in sas?
What is the maximum length of the macro variable? : sas-macro
What do the PUT and INPUT functions do?
What is the use of %include statement?
What is the difference between %local and %global? : sas-macro
what is the difference between nodup and nodupkey options? : Sas programming
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
What is the difference between using drop = data set option in data statement and set statement?
What can be the size of largest dataset in SAS?
What are the data types that sas contain?