Explain the message 'Merge has one or more datasets with
repeats of by variables'.
- 5 Answers
- 19494 Views
- I also Faced
- E-Mail Answers
Answer Posted / pricil kurian
This message occur when we merge two datasets having the by
variables with more than one observation in both datasets.
In such scenarios we can't tell the result is true...We are
expecting really a carteisan product in such situation but
it is not the case..Inside the by values it will do a 1-1
merge only. So this note is very important. Use
nomergeby=error option in sas as a option so that we will
get this message as a error. This will avoid ignoring this
message. Use proc sql to merge the dataset such type
situation and proc sql will give a carteisan product. If u
are doing with datastep create unique variable and then
merge.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Compare sas with other data analytics tools.
Describe a time when you were really stuck on a problem and how you solved it?
what other sas products have you used and consider yourself proficient in using? : Sas programming
what does the run statement do? : Sas programming
AE datasets names? how many types?
What are the statements in proc sql?
explain what is factor analysis? : Sas-administrator
What is PROC in SAS?
how to remove duplicates using proc sql?
what do the pad and dim functions do? : Sas programming
Explain translate function?
What is the function of output statement in a SAS Program?
What are the functions used for character handling?
Why double trailing @@ is used in input statement?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
