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
Test to compare Positive and Negative Predictive Value?Hi all, I wonder if its possible use a test to compare Positive and Negative Predictive Value with …
Changing a discrete variable into a dummy and loosing significanceDear all, I am writing an essay using an unbalanced panel dataset. Right now I am using a Linear Pr…
Merged file size is ~5X the source: Mechanism behind MergeHello, This is my first post on Statalist and I have tried my best to follow posting advice in the …
IV variable option in Stata program syntaxHello I am trying to write a program to run a regression based on some criteria and I want to add t…
generating dummy variables for consecutive yearsHi everyone! I am quite new to Stata and I probably have a simple question, but I am not able to fi…
Subscribe to:
Post Comments (Atom)
0 Response to unsuccessful merge
Post a Comment