what is the difference between SET and MERGE?
Answer Posted / chiranjeevi
MERGE:Merge statement is used to combine two datasets,The
two datasets can be combined by matching variable should by
specify by using statement calld 'by' in the data step.
SET:SET statement concatenates the two data sets by matching
variable.
Difference:when ever we are using the merge statement it
will over writes the existing and the similar observations
across two datasets,But where as the set statement doesn't
overwrites it.
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What is the purpose of trailing @ and @@? How do you use them?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
what do the pad and dim functions do? : Sas programming
Where do you use proc means over proc freq?
In ARRAY processing, what does the DIM function do?
Have you ever used the SAS Debugger?
Explain the use of proc print and proc contents?
What would you change about your job?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Compare sas with other data analytics tools.
Explain substr function?
why a stop statement is needed for the point= option on a set statement?
where to use sas business intelligence? : Sas-bi
what is SAS OPTIMIZATION?