I have read on this User Forum that IPUMS CPS does not have household or person unique identifiers that can be used to merge IPUMS CPS data to NBER CPS data. However because IPUMS and NBER data are sorted the same upon download, I can do a sequential merge as described here.
However, the sequential merge will only work if I’m merging one year to one year of March ASEC data, correct? For example, I cannot download 5 years of March data (say 2009-2013) from IPUMS and then expect that to be able to sequentially merge with NBER data over the same time period. If I want to do this sort of thing, then would be the process be something like this?:
Download and sequentially merge single year ASEC data from NBER and IPUMS CPS for each of the five years.
Create unique IDs for each person record by concatenating YEAR and some other variables (do you have a recommendation for these variables?)
Append the five merged IPUMS/NBER datasets together to get a final 5-year dataset with both NBER and IPUMS variables.
Would this be a good way to obtain a five-year dataset with unique person-records and both IPUMS and NBER variables/data?
Thanks for any advice