how many types of MERGE?

Answers were Sorted based on User's Feedback



how many types of MERGE?..

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

how many types of MERGE?..

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

how many types of MERGE?..

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

how many types of MERGE?..

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

how many types of MERGE?..

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

how many types of MERGE?..

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

how many types of MERGE?..

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

how many types of MERGE?..

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

how many types of MERGE?..

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

how many types of MERGE?..

Answer / srilatha

the types of merge are
1) one to one merging
2) match merging

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SAS Interview Questions

%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help

2 Answers  


What are the default statistics that proc means produce?

0 Answers  


what is data governance? : Sas-di

0 Answers  


What is connection profile? : sas-grid-administration

0 Answers  


What is your favorite all time computer book? Why?

0 Answers   Oracle,






What is LOGICAL VARIABLES in SAS.And how it can be used..Can anyone support..???

3 Answers  


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?

0 Answers  


What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?

3 Answers   TCS,


In the flow of DATA step processing, what is the first action in a typical DATA Step?

6 Answers   Accenture,


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

0 Answers  


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

0 Answers  


Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated

1 Answers  


Categories