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
How substr function works in sas?
Tell me about % include and % eval? : sas-macro
For clinical entire study how many tables will create approx?
What is a put statement?
What is a method to debug and test your SAS program?
What are the 3 components in sas programming?
What do you know about symput and symget?
How to create an external dataset with sas code?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
how can you import .csv file in to sas? : Sas programming
How to limit decimal places for the variable using proc means?
What would be the value of month at the end of data step execution and how many observations would be there?
explain the concepts and capabilities of business object? : Sas-bi
How can you create a macro variable with in data step? : sas-macro
Differentiate between sas functions and sas procedures.