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
Name some categories in sas 9? : sas-grid-administration
What are the features of base sas system?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What are the data types in sas?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
List out some key concept of SAS
why a stop statement is needed for the point= option on a set statement?
What are the 3 components in sas programming?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
In SAS explain which statement does not perform automatic conversions in comparisons?
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
What are types of transport files?
What are the features of SAS?
Explain how you can debug and test your SAS program?