首页资讯 number of children？

number of children？

来源：泰然健康网时间：2025年04月18日 13:08

I am also trying to calculate the number of children for adult respondent. The following are stata commands. But the proportion of childless seems high. Could any expert could tell if there are any problems with the stata commands below? Many thanks in advance.

*Number of children within the household

generate a006 = .
foreach x of varlist a006_1_-a006_16_ {
generate `x'1 = 1 if `x' == 7
replace `x'1 = 0 if !missing(`x') & `x' != 7
replace a006 = . if missing(`x'1) & missing(a006)
replace a006 = `x'1 + a006 if !missing(`x'1) & !missing(a006)
replace a006 = `x'1 if !missing(`x'1) & missing(a006)
replace a006 = a006 if missing(`x'1) & !missing(a006)
}

* Number of children obtained by adding the number of children of their own within
* &not within the household&adopted children not within the household

generate Bio_Child_Out = cb001 if !missing(cb001)
replace Bio_Child_Out = 0 if missing(cb001)
generate Ado_Child_Out = cb009 if !missing(cb009)
replace Ado_Child_Out = 0 if missing(cb009)
generate Child_Num = a006 + Bio_Child_Out + Ado_Child_Out
label variable Child_Num "Number of Children"

. tab Child_Num

Number of |
Children | Freq. Percent Cum.
------------+-----------------------------------
0 | 796 11.74 11.74
1 | 3,327 49.05 60.78
2 | 1,497 22.07 82.85
3 | 565 8.33 91.18
4 | 287 4.23 95.42
5 | 170 2.51 97.92
6 | 87 1.28 99.20
7 | 34 0.50 99.71
8 | 15 0.22 99.93
9 | 3 0.04 99.97
10 | 2 0.03 100.00
------------+-----------------------------------
Total | 6,783 100.00