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
marginscontplot problem.Dear All, I have a dataset with two variables (simplified). The basic statistics Code: . sum indep…
Creating fiscal month given fiscal year end monthDear Stata Users, Please, help me with the following issue. I have a data uploaded below. What I ne…
Clean syntax in STATAhi, please help me! I found command that is not recognized in STATA14 but is used in Chaney2012 pape…
How to create a formlacode year var2 top5 1100 201712 5 1 1100 201712 5 2 1100 201712 5 3 1100 201712 4.9 4 1100 201712 4.…
Can you combine data vertically?I am looking at data on methods of recycling for towns in the UK for five years, however my data on …
Subscribe to:
Post Comments (Atom)
0 Response to unsuccessful merge
Post a Comment