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 |
how would you determine the number of missing or nonmissing values in computations? : Sas programming
data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above code how to convert character data values to numeric data values?
what is the prob plot in clinical domain
What would be the value of month at the end of data step execution and how many observations would be there?
what is the difference between proc means and proc tabulate?
Approximately what date is represented by the SAS date value of 730?
HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?
What is the order of evaluation of the comparison && logical && relational operators:?
For what purpose(s) would use the RETURN statement?
where to use sas business intelligence? : Sas-bi
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
what are several options for creating reports in web report studio? : Sas-bi