Hello,

I am trying to generate the variable that captures the number of members whose age is under 18 in a household.
My data is household-level data, thus the information on each member of the household is widely recorded.
To show how the data is structured:
Code:
 dataex year hid age h2_age h3_age h4_age h5_age h6_age h7_age h8_hage h9_age
where h*_age represents the *the household member

And I got this:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input float year int(hid age h2_age) byte(h3_age h4_age h5_age h6_age h7_age h8_hage h9_age )
0   1 64  .  .  .  . . . . .
0   2 63 60 36  .  . . . . .
0   3 58  .  .  .  . . . . .
0   4 29 29  1  .  . . . . .
0   5 58 36  .  .  . . . . .
0   6 69 65 11  .  . . . . .
0   7 90  .  .  .  . . . . .
0   8 38 39  3  .  . . . . .
0   9 54 50  .  .  . . . . .
0  10 32  .  .  .  . . . . .
0  11 26  .  .  .  . . . . .
0  12 34 29  1  .  . . . . .
0  13 60  .  .  .  . . . . .
0  14 59 62 33 25  . . . . .
0  15 38  .  .  .  . . . . .
0  16 60  .  .  .  . . . . .
0  17 39 27  1  .  . . . . .
0  18 52  .  .  .  . . . . .
0  19 64  .  .  .  . . . . .
0  20 60 62  .  .  . . . . .
0  21 59 56 26 24 18 . . . .
0  22 63 60 89  .  . . . . .
0  23 53 25  .  .  . . . . .
0  24 88  .  .  .  . . . . .
0  25 75 71 42  .  . . . . .
0  26 64 63 35  .  . . . . .
0  27 63 68  .  .  . . . . .
0  28 42  .  .  .  . . . . .
0  29 63 68  .  .  . . . . .
0  30 73  .  .  .  . . . . .
0  31 67 38  .  .  . . . . .
0  32 77 49  .  .  . . . . .
0  33 61 84  .  .  . . . . .
0  34 40 41  5  .  . . . . .
0  35 62  .  .  .  . . . . .
0  36 47 47 16 13  . . . . .
0  37 53 55 28  .  . . . . .
0  38 43 41 14 11  . . . . .
0  39 44 38 12 10  . . . . .
0  40 62 64  .  .  . . . . .
0  41 53 47  9  7  . . . . .
0  42 73 72 43  .  . . . . .
0  43 43 42  .  .  . . . . .
0  44 39 34  .  .  . . . . .
0  45 82 76  .  .  . . . . .
0  46 70 64  .  .  . . . . .
0  47 66 59 33  .  . . . . .
0  48 63  .  .  .  . . . . .
0  49 70  .  .  .  . . . . .
0  50 76  .  .  .  . . . . .
0  51 26 30  .  .  . . . . .
0  52 48 56  .  .  . . . . .
0  53 56 23  .  .  . . . . .
0  54 49 49  9  .  . . . . .
0  55 77  .  .  .  . . . . .
0  56 48  .  .  .  . . . . .
0  57 54  .  .  .  . . . . .
0  58 59  .  .  .  . . . . .
0  59 37 35  .  .  . . . . .
0  60 50 43 15 13  . . . . .
0  61 71 66  .  .  . . . . .
0  62 73  .  .  .  . . . . .
0  63 60 27  .  .  . . . . .
0  64 78 69  .  .  . . . . .
0  65 73 71 42 40  . . . . .
0  66 64 57  .  .  . . . . .
0  67 43 41 11  9  . . . . .
0  68 45 43 14  7  . . . . .
0  69 43 39 12  8  . . . . .
0  70 76 74  .  .  . . . . .
0  71 50 48 21 19  . . . . .
0  72 56  .  .  .  . . . . .
0  73 85  .  .  .  . . . . .
0  74 51  .  .  .  . . . . .
0  75 67 63 39 38  . . . . .
0  76 66 68  .  .  . . . . .
0  77 40 40 18 10  . . . . .
0  78 70 67  .  .  . . . . .
0  79 61  .  .  .  . . . . .
0  80 39  .  .  .  . . . . .
0  81 71 70  .  .  . . . . .
0  82 40  .  .  .  . . . . .
0  83 56  .  .  .  . . . . .
0  84 47 44 16 12  . . . . .
0  85 56 55 31  .  . . . . .
0  86 31  .  .  .  . . . . .
0  87 26  .  .  .  . . . . .
0  88 46  .  .  .  . . . . .
0  89 39 33  .  .  . . . . .
0  90 47 46 19 18  . . . . .
0  91 48 43  9  .  . . . . .
0  92 49 48 17 15  . . . . .
0  93 35 37  .  .  . . . . .
0  94 62 71  .  .  . . . . .
0  95 52 78  .  .  . . . . .
0  96 69 28 24  .  . . . . .
0  97 29  .  .  .  . . . . .
0  98 29  .  .  .  . . . . .
0  99 22  .  .  .  . . . . .
0 100 37  .  .  .  . . . . .
end
------------------ copy up to and including the previous line ------------------

Listed 100 out of 32215 observations
Use the count() option to list more

I would like to generate the variable that counts the number of children in the household.

I tried something like this, but it didn't work (I am not familiar with using forvalues..)

Code:
forvalues i=2/7 {
    gen age_`i'=1 if h*_age<19    
}
egen child=rowtotal(age_`i')
Would you please help me solve this problem?

Thank you so much for your time and consideration!

Jiwan