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
Explain data_null_?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
What is the difference between match merge and one to one merge?
Mention common programming errors committed in sas ?
How do you delete duplicate observations in sas?
how will you location sas platform applications available from web browser? : Sas-bi
I need level 2 to 5 sas using companies in india
how are numeric and character missing values represented internally? : Sas programming
What is the difference between INPUT and INFILE ?
what is sas olap server? : Sas-di
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
what is sas data set?
what is sas metadata repository? : Sas-bi
What is the difference between SAS functions and procedures?
How many data types are there in SAS?