I would like to merge two datasets, one using ACS data (2008-2016) and the other with ASEC CPS data (2008-2016). The ‘serial’ variable in both datasets that is supposed to link the two does not seem to work (only matches about 10% and demographic variables don’t match), even when uniquely merged alongside ‘pernum’ and ‘year’.
How should I merge these two datasets? I really only need a couple of variables from the CPS dataset, but at this point I can’t rely on any analysis involving merged observations.
I’m using STATA for analysis.
Any advice would be appreciated!