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
How substr function works in sas?
what do the pad and dim functions do? : Sas programming
what are informats in sas? : Sas-administrator
What is the differnce between SDTM 3.1.2 to 3.1.1 version
what is the difference between floor and ceil functions in sas? : Sas-administrator
explain what is data set in sas? : Sas-administrator
What is your favorite all time computer book? Why?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
why a stop statement is needed for the point= option on a set statement?
what does the run statement do? : Sas programming
what is study design in while working with SAS? what are screening variables in SAS?
Differentiate between ceil and floor functions.
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming