Hello everyone!
I am trying to merge two data files from different sources using the command merge 1:1, based on a string variable Country. However, the merge is never successful, even though the names of countries in both data sets are identical.
I suspect this is because each of the data files has Country saved as a different type of variable (str42 and str30). When I try to merge, Stata tries to adjust the data (note: variable Country was str30, now str42 to accommodate using data's values) which, I believe, causes the merge to fail.
Is there any way to deal with this issue?
Any help is very appreciated.
Thanks in advance,
Barbora
Related Posts with unsuccessful merge
panel data - time dummies problemHello everyone! I will try to be as precise and concise as possible. ***** SET UP****** I'm study…
test of differences in means (and medians) test between MNCs and domestic firmsDear all, After advising this forum hundreds of times for using STATA, I think its time to express …
Minutes and seconds coming out wrong with dhms() %tcI am constructing a date-time variable in 2 steps, using variables for year, month, day, hour, minut…
Query regarding appropriate ROC curve functionDear all I am calculating the ability of a diagnostic angle measurement that can differentiate betw…
Outputting Multiple tables in the same word file using outreg2 Code: reg price treatment i.state ib2007.year i.sector , cluster(state) outreg2 using "${path}\Tab…
Subscribe to:
Post Comments (Atom)
0 Response to unsuccessful merge
Post a Comment