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


Is there a way that I can convert a DAT file to a STATA file? If so, how is t...
Underlying files for CPS Education Supplements (October)?
Income varialbe values & US variable
Why there is no data for 'VLHALLORG"
.CVS format data uploaded into EXCEL
County Codes
Login   |   Register

Recently Active Members

View More »

Share |