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
it will become easy if uuu provide website linkssss and list of consultanciessssss
Explain the difference between informat and format with an example.
In ARRAY processing, what does the DIM function do?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What are the data types that sas contain?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
how does sas handle missing values in sort order? : Sas programming
What is the difference between one to one merge and match merge? Give an example.
What would you change about your job?
what are the benefits of data integration? : Sas-di
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
I need level 2 to 5 sas using companies in india
What is interleaving in SAS?
What are the data types in sas?
Are you sensitive to code walk-throughs peer review or QC review?