Re: st: Generating dummy variable with information of household survey from different observations

[Eric Booth <eric.a.booth@gmail.com>]

<>

***************!
clear
inp household_id   individual_id   father_row   
 1011     1    .   
 1011     2    .   
 1011     3    1   
 1011     4    1   

 1012     1     2  
 1012     2     .  

 1013      1    .  
 1013      2    .  
 1013      3    2  
 1013      4    1  
 1013      5    1  
 end


levelsof individual_id, loc(a)
reshape wide father_row, i(household_id) j(individual_id)
ds father_row*
loc checklist `r(varlist)'
loc checklist:subinstr loc checklist " " ", " , all
foreach n in `a' {
	 g father`n' = cond(inlist(`n', `checklist'), 1, 0, .)
	}	
reshape long father_row father, i(household_id) j(individual_id)


***************!
- Eric

__
Eric A. Booth
Public Policy Research Institute 
Texas A&M University
ebooth@ppri.tamu.edu
+979.845.6754

On May 6, 2012, at 10:34 PM, Sumiko Hayasaka wrote:

> I am trying to generate a dummy variable, with information from a
> household survey, which can tell if a member of the household is a
> father or not. I have a household id, an individual id (per
> household), and a variable that tells me which individual id is marked
> as being a father (members of the family are asked if their father
> lives in the household and to give their father's individual id).
> Therefore, I need to assign a 1 at the row in which someone at the
> household said that was a father. To illustrate this, the data is
> something like this (I am trying to get the "father" variable):
> 
> household_id   individual_id   father_row   father
> ------------------------------------------------------------------------
>  1011                 1                      .                1
>  1011                 2                      .                0
>  1011                 3                      1               0
>  1011                 4                      1               0
> 
>  1012                 1                       2               0
>  1012                 2                       .                1
> 
>  1013                  1                      .                1
>  1013                  2                      .                1
>  1013                  3                      2               0
>  1013                  4                      1               0
>  1013                  5                      1               0
> 
> 
> So, for example, members number 3 and 4 of household number 1011
> stated that their father is individual number 1 in that household.
> This means that I have to put the 1 of "father" (meaning the household
> member is a father) at the row where father_row indicates (no matter
> how many times this is done).
> 
> Is there any way in which I can do this? I really appreciate your
> help! Thank you!
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/