Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the message 'Merge has one or more datasets with
repeats of by variables'.
- 5 Answers
- 20819 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
how many display types available in sas bi dashboard? : Sas-bi
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
Explain data_null_?
What is the maximum length of the macro variable?
For what purposes have you used sas macros? : sas-macro
What is connection profile? : sas-grid-administration
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
How would you determine the number of missing or nonmissing values in computations?
what are the categories that sas informats are used to the place the data? : Sas-administrator
what is the difference between unique key and primary key? : Sas-di
What are the special input delimiters used in SAS?
What do the mod and int function do? : Sas programming
How to sort in descending order?
how the sas basic syntax style described? : Sas-administrator
what is change analysis in sas di ? : Sas-di
