Question

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

How to assign children's information to the parents?

Hello,


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!

Shreya

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Jeff Bloem

Staff

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

1
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

sorry, i didn't see this in the FAQ/tutorials. i want to *just* download CPI...
The highest one percent incwage earners are combined into the incwage"Top Cod...
To compute unemployment rates from Ipums-I, should I use perwt as pweights or...
Why is the income wage variable incwage-capped? and how is the cap determined...
USA IPUMS 1980 ancestry variable -- mapping to country names
Did the version of database change since 2011?
Login   |   Register

Recently Active Members

View More »

Share |