Explain the message 'Merge has one or more datasets with
repeats of by variables'.
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
what type of graphs we will create(for 2+years candidates)?
What is the length assigned to the target variable by the scan function?
How do you delete duplicate observations in sas?
What are the statements that are executed only?
What are the differences between proc means and proc summary?
What function CATX syntax does?
How does proc sql work?
What is the role of sas grid administrator? : sas-grid-administration
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
what is sas application server? : Sas-di
what are the categories that sas informats are used to the place the data? : Sas-administrator
What can be the size of largest dataset in SAS?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
How would you determine the number of missing or nonmissing values in computations?
Approximately what date is represented by the SAS date value of 730?