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!