I have 3 excel files with poverty data at the county level for the years 1980,1990, and 2000. I have tried using the merge function to no avail. The counties correspond by state, countyname and code, but I can't seem to figure out how to properly merge them. Here is a screenshot of what they look like once I have processed them as STATA files. I am trying keep the identifying variables and only add the unique columns side-by-side.
Array Array