Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH
REPEATS OF BY VARIABLE’.
Answers were Sorted based on User's Feedback
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 |
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 |
wt is a-z and a--z?
Which statement does not perform automatic conversions in comparisons?
which domain is better in sas? clinical trails or banking
what is information maps?
if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record
explain the function of substr in sas? : Sas-administrator
what is sas business intelligence? : Sas-bi
how can you sort the dataset having millions of OBS(instead of sort procedure?
Name statements that are recognized at compile time only?
what is sas metadata server? : Sas-di
How do you add a number to a macro variable?
What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?