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 softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
explain what is factor analysis? : Sas-administrator
how do you want missing values handled? : Sas programming
How do you debug and test your SAS programs?
What is the SAS data set?
for what purpose would you use the retain statement? : Sas programming
What are the functions used for character handling?
how does sas handle missing values in formats? : Sas programming
What is the difference between nodupkey and nodup options?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
where are dashboard components are created and maintained? : Sas-bi
If money were no object, what would you like to do?
What is the difference between reading data from an external file and reading data from an existing data set?
explain about various caches available in data integrator? : Sas-di
Give some examples where proc report’s defaults are same as proc print’s defaults?