Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Re: assigning household characteristics to an individual with missing values


From   Friedrich Huebler <huebler@rocketmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Re: assigning household characteristics to an individual with missing values
Date   Wed, 1 Mar 2006 11:23:09 -0800 (PST)

Marilyn,

Out of curiosity, what kind of data has households in which everyone
is either a father, mother, son, or daughter? What if there is no
father or more than one father in a household? Wouldn't it be more
precise if you had a variable that actually identifies the household
head, which may be simply the person listed first in each household?

Friedrich Huebler

--- "Ms. Marilyn Ibarra" <ibarra@uga.edu> wrote:
> 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 
> not receive.  
> 
> 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 
> values.
> 
> Marilyn. 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2020 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index