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 sas database server? : Sas-di
Of all your work, where have you been the most successful?
What is maximum number of rows and cols can be handled in SAS?
what is study design in while working with SAS? what are screening variables in SAS?
Differentiate input and infile.
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
What do you code to create a macro? : sas-macro
What is by-group processing?
it will become easy if uuu provide website linkssss and list of consultanciessssss
What are the different servers in sas? : sas-grid-administration
Approximately what date is represented by the SAS date value of 730?
What are the difference between the sas data step and sas procs?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
Describe the ways in which you can create macro variables? : sas-macro