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 |
What is the role of sas grid administrator? : sas-grid-administration
What is the difference between input and infile statement?
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
Explain append procedure?
How would you include common or reuse to be processed along with your statements?
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?
define table lookup and how may ways it can be done...explian
For what purpose would you use the RETAIN statement?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
What are the scrubbing procedures in sas?
What are the main differences between sas versions 8.2, 9.0, 9.1?
Why is SAS considered self-documenting?