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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1767


Explain the difference between informat and format with an example.

963


In ARRAY processing, what does the DIM function do?

954


what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4171


What are the data types that sas contain?

935


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

930


how does sas handle missing values in sort order? : Sas programming

759


What is the difference between one to one merge and match merge? Give an example.

841


What would you change about your job?

2172


what are the benefits of data integration? : Sas-di

786


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2553


I need level 2 to 5 sas using companies in india

2160


What is interleaving in SAS?

893


What are the data types in sas?

838


Are you sensitive to code walk-throughs peer review or QC review?

2938