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
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
What is the basic structure of the SAS base program?
what is slowly changing dimension? : Sas-di
How do you test for missing values?
Describe a time when you were really stuck on a problem and how you solved it?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
Briefly explain input and put function?
for what purpose would you use the retain statement? : Sas programming
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
Name types of category in which SAS Informats are placed?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What are the advantages of using sas?
What are the new features included in the new version of SAS Programming Language?