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

How substr function works in sas?

929


what do the pad and dim functions do? : Sas programming

812


what are informats in sas? : Sas-administrator

824


What is the differnce between SDTM 3.1.2 to 3.1.1 version

4865


what is the difference between floor and ceil functions in sas? : Sas-administrator

972


explain what is data set in sas? : Sas-administrator

770


What is your favorite all time computer book? Why?

2283


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

988


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3378


what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

807


why a stop statement is needed for the point= option on a set statement?

843


what does the run statement do? : Sas programming

816


what is study design in while working with SAS? what are screening variables in SAS?

1950


Differentiate between ceil and floor functions.

925


what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

808