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 are the default statistics for means procedure?
Does anybody has SAS Platform Administration certification dumps. pls send to hariithepalli@gmail.com
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?
what is validvarname and varnum? why we are using this options; explain with a syntax for this options?
I need level 2 to 5 sas using companies in india
what is the SAS/ACCESS and SAS/CONNECT?
9 Answers Accenture, iFlex, TCS,
What's the difference between VAR A1 - A4 and VAR A1 - A4?
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
Mention the difference between ceil and floor functions in sas?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
What do you feel about hardcoding?