Status:Closed    Asked:Mar 05, 2017 - 04:29 PM

How to assign children's information to the parents?


I am trying to calculate the amount EITC claimed by each household from 1990-1999 in STATA. EITC is based on taxfiler's income, number of qualifying children (less than 19 years of age) and marital status. I have created a vriable showing which children are qualifying. Now I want to tie this infomration to the houehold head because they are the ones who will claim the children and receive the EITC. How do I link the information, whether a child is qualifying to their parent i.e. how do I create a variable showing the number of qualifying children the head of houeshold has. I have a serial and cpsid variable that identifies the household but when I sort it, it mixes things up. I am using monthly basic sample for cps.

I have tried the command: collapse (count) qual_child, by (cpsid)

and got nowhere. I think there is an issue with the household identifier that I am not seeing.

Thank you for your help!


Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


The most straightforward way to do this is to make the IPUMS extract system do the work for you. Before finalizing your data extract, use the "Attach Characteristics" tool. This feature can attach a characteristic of a person's mother, father, spouse, or household head as a new variable on the person's record. There is likely a way to do this in STATA, but it will require a bit of coding. So, I'd recommend using the Attach Characteristics feature of the IPUMS data extract system.


Mar 06, 2017 - 09:35 AM

Report it


problem loading data in stata 10
South & Central America CPS
Missing observation from Regency Aceh Tenggara in Indonesia 1971 census
Hi is there a way to get the foreign born population for a city (Elizabeth, N...
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)?
Login   |   Register

Recently Active Members

View More »

Share |