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
What is factor analysis?
what is snowflake schema? : Sas-di
what are the best practices to process the large data sets in sas programming? : Sas-administrator
what is data governance? : Sas-di
what is business intelligence? : Sas-bi
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
what is the difference between unique key and primary key? : Sas-di
What is the difference between input and infile statement?
What is the maximum and minimum length of macro variable
explain about data integrator metadata reports? : Sas-di
What is the difference between %local and %global? : sas-macro
How does proc sql work?
What is a pdv and what are its functions?
what is the function of catx syntax? : Sas-administrator
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?