Status:Closed    Asked:Feb 23, 2018 - 04:55 PM

when trying to declare the IPUMS data as panel on stata there are repeated time values with id as serial no.

I use data from 1980 to 2017 for the month of March, for variables incomewage, education, occupation2010, union and states.

Do you have the same question? Follow this Question

Staff Answer

It sounds like you are trying to create a panel data set using SERIAL as your linking variable. As noted here, SERIAL is unique only to each household in a given survey month and year. Therefore, it sounds like you just need to identify the correct linking variable(s) for your analysis. Below is some information about linking household with IPUMS CPS data.

CPSID is an IPUMS-CPS defined variable that uniquely identifies households across CPS samples.

If you wish to link the March Basic samples to the March ASEC samples, you can use MARBASECIDP.

If you wish to link ASEC samples to other ASEC samples, you can use HRHHID with HRHHID2 for the years 2004-present and HRHHID prior to 2004.

I hope this helps.


Feb 25, 2018 - 05:00 PM

Report it


Does a serial number (SERIAL) correspond to a combination of the two househol...
I am trying to calculate state by month unemployment rates for 2012,but March...
Will both the extensive March CPS data for 2015, and the 2014 monthly data be...
IPUMS CPS is a rotating panel. Can I use panel data for two consecutive year...
Login   |   Register

Recently Active Members

View More »

Share |