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 regressionHello, Greeting to all! Please I am trying to test the consequences of exchange rate regime and capi…
Syntax for By var: with IF statementThis is not a pressing matter as I easily found a work-around, I was just curious if anyone could te…
reshaping bilateral dataDear Statalist members, I have an issue to reshape the bilateral exchange rate data, could someone …
Continuous threshold model (Kink threshold model)Hey all, What's the difference between the threshold model that can divide the sample into two regi…
Compare: Logit regress with Categorical variables with Chi2 testDear all, I have problem with Logit regress. PHP Code: use https://thongke.club/data/logit.dt…
Subscribe to:
Post Comments (Atom)
0 Response to unsuccessful merge
Post a Comment