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
what are the considerations when picking a SAS/STAT procedure?
What are the new features included in the new version of SAS Programming Language?
describe about physical data integration? : Sas-di
what is data governance? : Sas-di
What is your favorite all time computer book? Why?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
how do you want missing values handled? : Sas programming
Describe the function and untility of the most difficult SAS macro that you have written.
What is substr function?
what is the difference between infile and input? : Sas-administrator
explain about data integrator metadata reports? : Sas-di
What is the use of stop statement?
how will you location sas platform applications available from web browser? : Sas-bi
Can you execute a macro within a macro? Describe. : sas-macro
What are the five ways to do a table lookup in sas? : sas-grid-administration