I have an odd problem merging two files based on state variables, called est_st. In both data sets, there are 51 values of est_st, for each of the 50 states and DC. All observations are complete in each data set and there are no other values. I have them both converted to byte variables with %8.0g.
But when I try to merge m:1, the states WA, WI, WV and WY don't merge and and some new values of est_st are created with values like 3, 14, etc.
My code is
merge m:1 est_st using pres2020medexpand.dta
Any clue as to why my data aren't merging correctly?
Related Posts with merging errors m:1
Inequality IndicatorsHello I have the cost of every household and the per capita cost of every household What codes shoul…
Drop if - variable not foundHi all, Just a very simple question and command yet I can't figure out why it is not working. I ju…
Problem with capture confirm and graph combine Hello. I have problems combining two graphs in a loop . I do not have all of the combination …
Pseudo R2HI, I'd be grateful if you could help me clarify this please. I have performed 2 mutlivariate logsi…
Manipulating datatimeHi all, my dataset is like that: id data time 1 01jan2018 1 01jan2018 1 03jan2018 1 03jan2018 1 03j…
Subscribe to:
Post Comments (Atom)
0 Response to merging errors m:1
Post a Comment