Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH
REPEATS OF BY VARIABLE’.

Answers were Sorted based on User's Feedback



Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’. ..

Answer / siri

This is the note obtained in log while performing many-to-
many merge refering the situation of having duplicate
values for key variables in both input files simultaneously.

Is This Answer Correct ?    6 Yes 0 No

Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’. ..

Answer / christeena

this happens in many to many merge..if we do not have a key
variable to identify that which observation from one data
set to be matched with which observation in the other data
set, a note will appear in the log as 'merge with repeat
set of by values'..So to get rid of this note find a unique
key variable so that observations from the data sets can be
correctly matched..

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More SAS Interview Questions

how to debug and test the sas program? : Sas-administrator

0 Answers  


what is hash files in sas and why we are using this one in sas?

0 Answers   L&T, SAS,


Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.

1 Answers  


it will become easy if uuu provide website linkssss and list of consultanciessssss

0 Answers  


What is the basic syntax style in SAS?

0 Answers  


Do you know the features of sas?

0 Answers  


Explain bmdp procedure?

0 Answers  


How do you download a flat file from Mainframe to your local PC using SAS?

3 Answers  


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

0 Answers  


Enlist the functions performed by sas.

0 Answers  


what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

0 Answers  


diff between nodup rec and ondup key???

3 Answers   AON, Sciformix,


Categories