stata中数据识别问题

求助！用的家庭调查的数据，每个家庭都有一个编号（hhcode），家庭成员个数不定。我现在想识别某类人群（比如50岁以上的女性）家中是否有6岁以下的小孩，该如何处理。数据中有家庭成员关系（与户主关系），可以使用。

我认为如果该女性为户主的话，识别子女或孙子女；若不是的话则先识别与户主的关系再去识别户主与孩子的关系。但是代码还是不会写，希望能帮忙写一个样例以便在下模仿，万分感谢！

1. gen age = 2016 - a04_1 /// generate age
   
2. 
   
3. /// drop hh without kids less than 6 yrs
   
4. by hhcode: egen kid6 = min(age)
   
5. gen ind_kid6 = kid6 < 6
   
6. drop if ind_kid == 0
   
7. drop ind_kid
   
8. 
   
9. /* assume there is a gender variable in your dataset,
   
10.    gender = 0 for male and gender = 1 for female */
    
11. gen female_ind = 1 if gender == 1 & inlist(a02, 4, 6) & age > 50
    
12. replace female_ind = 0
    
13. by hhcode: egen ind = max(female_ind)
    
14. drop if ind == 0
    
15. drop ind
    
16. drop female_ind
    
17. 
    
18. /* All the households in your sample: 1) have at least one female mother
    
19.         or grandmother over 50 years old, and 2) have at least one kid less than
    
20.         6 years old. Households with grandmother less than 50 years are excluded. */

复制代码

austen06 发表于 2016-12-11 13:40

十分感谢，给了我很大启发！