Explain the message 'Merge has one or more datasets with
repeats of by variables'.
- 5 Answers
- 18965 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vimal
If we are merging two datasets,
say,
a b
100 100
100
data x;
merge a b;
by id;
in this case, b has by variable repeated twice.
so the warning occurs.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / upendra
it meens that by variable uesd in merge has more than one
record for observation.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / pari
merge,is performed under conditional criteria, thus we could
merge one or many datasets with repeats of a particular
variable using by statement.
| Is This Answer Correct ? | 1 Yes | 7 No |
what is _error_?
2 Answers Axis Bank, Cognizant, JPMorgan Chase,
What do you know about symput and symget?
what is data access? : Sas-di
how does sas handle missing values in formats? : Sas programming
How would you determine how far down on a page you have printed in order to print out footnotes?
hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?
what are sas/access and sas/connect? : Sas programming
How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;
what can you learn from the sas log when debugging? : Sas programming
What is the maximum length of the macro variable?
what is p-value
3 Answers Accenture, Quintiles, Sristek,
What SAS statements would you code to read an external raw data file to a DATA step?
Teradata 
