[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: Re: assigning household characteristics toan individual with missing values
I have the following:
Household ID Relationship Remits
1 father 1
1 mother 1
1 son 1
2 father .
2 mother .
2 son .
3 father 0
3 mother 0
3 daughter 1
I would like to create a Remit_hh varible that tells me if
the head of household (we can assume it is always father for
this simple example) receives remittances. Remits takes on
the value of 1 when the person receives and zero if they do
I tried the following:
generate remits_hh=remits if relationship==father
by hhid: replace remits_hh=sum(remits_hh)
It creates a problem where there are missing values, it
places a 0. I guess I can then say:
replace remits_hh=remits if remits==.
but is there a better way to get at this than having to do
the third command to all my variables that have missing
* For searches and help try: