what is the difference between SET and MERGE?
Answer Posted / ashok kore
Set : Its append the datasets is dataset by dataset at row
level. It's not need to sort the datasets before append
datasets.
Merge : Its merge the datasets according to conditions at
column level. It needs sort datasets by variable before
merge the datasets. It works like joins in Proc sql.
| Is This Answer Correct ? | 6 Yes | 14 No |
Post New Answer View All Answers
Explain the purpose of substr functions in sas programming.
What is the role of administrative users? : sas-grid-administration
What are the special input delimiters used in SAS?
What commands are used in the case of including or excluding any specific variables in the data set?
Mention what is the difference between nodupkey and nodup options?
In sas, what are the areas that you are most interested in? : sas-grid-administration
Give an example where SAS fails to convert character value to numeric value automatically?
do you need to know if there are any missing values? : Sas programming
what are sas bi dashboard components? : Sas-bi
What are the default statistics that proc means produce?
What is the difference between using drop = data set option in data statement and set statement?
Difference between SAS STATA & SPSS?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Differentiate between ceil and floor functions.
What is the difference between class statement and by statement in proc means?