Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the message 'Merge has one or more datasets with
repeats of by variables'.
- 5 Answers
- 21177 Views
- I also Faced
- E-Mail Answers
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 is the difference between class statement and by statement in proc means?
Mention what is the difference between nodupkey and nodup options?
If you could design your ideal job, what would it look like?
What are the default statistics that proc means produce?
In SAS explain which statement does not perform automatic conversions in comparisons?
What is data _null_?
what is the effect of the options statement errors=1? : Sas programming
explain the main difference between the nodup and nodupkey options? : Sas-administrator
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
what is hash files in sas and why we are using this one in sas?
What is the role of sas grid administrator? : sas-grid-administration
what versions of sas have you used (on which platforms)? : Sas programming
What is the difference between proportion and average?
Tell me more about the parameters in macro? : sas-macro
In proc transpose and data step with arrays which one you pick?
