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
Can I ignore bins with high p-valuesHello! I am analyzing the effect of wind on the fertility rate using a quadratic term of wind: Arra…
WDI dataDear Statalist, I would like to download WDI data that could also include the income_group and regi…
Days between two dates, separated by year.Hello statalist! I have a dataset in long format which measure enrollment under a period of time. E…
Herfindahl-IndexHello, i need the industry concentration (Herfindahl Index), calculated as the sum of squared marke…
Reference to other rowsDear all, I have a table (that results from dependency parsing) with some rows referencing to other …
Subscribe to:
Post Comments (Atom)
0 Response to unsuccessful merge
Post a Comment