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


Please Help Members By Posting Answers For Below Questions

Explain data_null_?

699


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

752


What is the difference between match merge and one to one merge?

782


Mention common programming errors committed in sas ?

722


How do you delete duplicate observations in sas?

671






how will you location sas platform applications available from web browser? : Sas-bi

656


I need level 2 to 5 sas using companies in india

2020


how are numeric and character missing values represented internally? : Sas programming

725


What is the difference between INPUT and INFILE ?

863


what is sas olap server? : Sas-di

815


If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

701


what is sas data set?

760


what is sas metadata repository? : Sas-bi

706


What is the difference between SAS functions and procedures?

765


How many data types are there in SAS?

727