how many types of MERGE?
- 17 Answers
- 23940 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vij
Two types
One - to -one mergeing:
combine observations from two data sets into a single
observation in a new data set:
Match- Merging:combine observations from two data sets into
a single observation in a new data set according to the
values of a variable that is specified in the BY statement:
| Is This Answer Correct ? | 16 Yes | 3 No |
Answer / vij/vijji
Two types
One - to -one mergeing:
combine observations from two data sets into a single
observation in a new data set:
Match- Merging:combine observations from two data sets into
a single observation in a new data set according to the
values of a variable that is specified in the BY statement
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
Answer / srinivas
Source:SAS
Link :
http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/a002645445.htm
SAS provides several different methods for combining SAS
data sets. In this section, you will be introduced to five
methods of combining data sets:
1)concatenating
2)interleaving
3)merging
4)updating
5)modifying
When it comes to Merging,there are two types:
1)One-to-one merging
2)Match merging
Thanks!
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / mr.s
according to the question ,there are 2 types of merging.they
are "one-one merge" &"one -many merging" there's no need of
nay deviation to the answer ok
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / name is no need
Arai Name Is No Need , i think you dont know anything, you
stupid try to encourage them or otherwise keep quiet , if
abuse anybody then definitely i can you . you idiot
...................................
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sakshi
there are three types of merging:
one to one
may to one or one to many
no match merge
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mallikarjuna reddy.vanna
4 types of merges are present.
they are
1.one to one merging
2.one to many
3.many to one
4.many to many
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / kishore
total 3 types of mergings are available
they are one to one merging, one to many merging, many to
many merging
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / srilatha
the types of merge are
1) one to one merging
2) match merging
| Is This Answer Correct ? | 1 Yes | 3 No |
How would you code the criteria to restrict the output to be produced?
What is the difference between Proc tabulate and Proc print
what is data governance? : Sas-di
How to merge the data using merge statement and proc format? Is the result is same ?
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
Tell me more about the parameters in macro? : sas-macro
How to write duplicate records into a separate dataset using sort?
List out some key concept of SAS
Which are the statements whose placement in the data step is critical?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
What is Transaction...? And what are Comment, Roll back n Save point..?
How do you specify the number of iterations and specific condition within a single do loop?
Teradata 
