how many types of MERGE?

Answer Posted / pricil kurian

Types of merges:-
1)one to one merge- It is the merge without any by variables
2)Match merges- Where we are using by variables.
Under match merge we have 1-1 , 1-many, and many-many
depending on the values in by variables.
For many-many merge proc sql will be relaiable.
Please correct me if I am wrong.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between %put and symbolgen? : sas-macro

913


What do you know about sas and what we do? : sas-grid-administration

801


Mention what is the difference between nodupkey and nodup options?

780


what is sas data set?

861


Hi, If anyone has base SAS certification dumps, please share.

1604


what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

770


Where do you use proc means over proc freq?

751


What are the differences between sum function and using “+” operator?

788


Are you involved in writing the inferential analysis plan? Tables specfications?

1967


Name any two sas spawners? : sas-grid-administration

769


What is substr function?

852


what is change analysis in sas di ? : Sas-di

783


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

844


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3255


What does PROC print, and PROC contents do?

960