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


Please Help Members By Posting Answers For Below Questions

what type of graphs we will create(for 2+years candidates)?

2089


What is the length assigned to the target variable by the scan function?

909


How do you delete duplicate observations in sas?

818


What are the statements that are executed only?

915


What are the differences between proc means and proc summary?

820


What function CATX syntax does?

907


How does proc sql work?

834


What is the role of sas grid administrator? : sas-grid-administration

1064


what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

1941


what is sas application server? : Sas-di

745


what are the categories that sas informats are used to the place the data? : Sas-administrator

811


What can be the size of largest dataset in SAS?

960


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1172


How would you determine the number of missing or nonmissing values in computations?

851


Approximately what date is represented by the SAS date value of 730?

990