hi I'm new in stata, and I need some help to resolve my problem
I want to calculate expenditure per adult equivalent in household
but i need to know how many members of adult in one houshold and how many number of children in one household and so on
this is the formula of Adult equivalence scale that I used
(Na + 0.7 Nc)^0.65
Note: Na = Number of adults. Nc = Number of children

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input byte(b1r1 b1r2) int(b1r3 b1r4) str1 b1r5 int b1r7 byte(b1r8 jk usia) float b1r1r
17 1 10  4 "2" 1001  1 1 52 17
17 1 10  4 "2" 1001  1 2 42 17
17 1 10  4 "2" 1001  1 1 20 17
17 1 10  4 "2" 1001  1 1 15 17
17 1 10  4 "2" 1001  1 1  9 17
17 1 10  4 "2" 1001  2 1 51 17
17 1 10  4 "2" 1001  2 2 47 17
17 1 10  4 "2" 1001  2 2 17 17
17 1 10  4 "2" 1001  2 2 14 17
17 1 10  4 "2" 1001  2 2 10 17
17 1 10  4 "2" 1001  2 2  7 17
17 1 10  4 "2" 1001  2 1 68 17
17 1 10  4 "2" 1001  3 1 48 17
17 1 10  4 "2" 1001  3 2 43 17
17 1 10  4 "2" 1001  3 1 18 17
17 1 10  4 "2" 1001  3 2  8 17
17 1 10  4 "2" 1001  3 1  6 17
17 1 10  4 "2" 1001  3 1 71 17
17 1 10  4 "2" 1001  4 1 57 17
17 1 10  4 "2" 1001  4 1 22 17
17 1 10  4 "2" 1001  5 1 51 17
17 1 10  4 "2" 1001  5 2 53 17
17 1 10  4 "2" 1001  5 2 25 17
17 1 10  4 "2" 1001  5 2 15 17
17 1 10  4 "2" 1001  5 2  8 17
17 1 10  4 "2" 1001  5 1 30 17
17 1 10  4 "2" 1001  5 2  4 17
17 1 10  4 "2" 1001  6 1 32 17
17 1 10  4 "2" 1001  6 2 28 17
17 1 10  4 "2" 1001  6 1  7 17
17 1 10  4 "2" 1001  6 1 68 17
17 1 10  4 "2" 1001  6 2 65 17
17 1 10  4 "2" 1001  7 1 36 17
17 1 10  4 "2" 1001  7 2 32 17
17 1 10  4 "2" 1001  7 1 11 17
17 1 10  4 "2" 1001  7 2  9 17
17 1 10  4 "2" 1001  8 1 46 17
17 1 10  4 "2" 1001  8 2 44 17
17 1 10  4 "2" 1001  8 1 17 17
17 1 10  4 "2" 1001  8 1 15 17
17 1 10  4 "2" 1001  8 2  9 17
17 1 10  4 "2" 1001  8 2  5 17
17 1 10  4 "2" 1001  8 2 71 17
17 1 10  4 "2" 1001  9 1 30 17
17 1 10  4 "2" 1001  9 2 29 17
17 1 10  4 "2" 1001  9 2  6 17
17 1 10  4 "2" 1001  9 1  4 17
17 1 10  4 "2" 1001  9 2  0 17
17 1 10  4 "2" 1001 10 1 62 17
17 1 10  4 "2" 1001 10 2 60 17
17 1 10  4 "2" 1001 11 1 60 17
17 1 10  4 "2" 1001 11 2 56 17
17 1 10  4 "2" 1001 11 1 30 17
17 1 10  4 "2" 1001 11 1 15 17
17 1 10  4 "2" 1001 11 2 25 17
17 1 10  4 "2" 1001 11 1  2 17
17 1 10  4 "2" 1001 12 1 40 17
17 1 10  4 "2" 1001 12 2 39 17
17 1 10  4 "2" 1001 12 1 16 17
17 1 10  4 "2" 1001 12 1 14 17
17 1 10  4 "2" 1001 12 2  6 17
17 1 10  4 "2" 1001 12 1 69 17
17 1 10  4 "2" 1001 12 2 73 17
17 1 10  4 "2" 1001 13 1 41 17
17 1 10  4 "2" 1001 13 2 43 17
17 1 10  4 "2" 1001 13 2 16 17
17 1 10  4 "2" 1001 13 1 13 17
17 1 10  4 "2" 1001 13 1 10 17
17 1 10  4 "2" 1001 13 1 75 17
17 1 10  4 "2" 1001 13 2 72 17
17 1 10  4 "2" 1001 14 1 38 17
17 1 10  4 "2" 1001 14 2 36 17
17 1 10  4 "2" 1001 14 2 11 17
17 1 10  4 "2" 1001 14 2  9 17
17 1 10  4 "2" 1001 14 1  3 17
17 1 10  4 "2" 1001 15 1 46 17
17 1 10  4 "2" 1001 15 2 44 17
17 1 10  4 "2" 1001 15 1 25 17
17 1 10  4 "2" 1001 15 1 15 17
17 1 10  4 "2" 1001 15 2 11 17
17 1 10  4 "2" 1001 15 2 25 17
17 1 10  4 "2" 1001 15 2  1 17
17 1 10  4 "2" 1001 16 1 48 17
17 1 10  4 "2" 1001 16 2 44 17
17 1 10  4 "2" 1001 16 1 14 17
17 1 10  4 "2" 1001 16 1 10 17
17 1 10 15 "2" 1002  1 1 36 17
17 1 10 15 "2" 1002  1 2 35 17
17 1 10 15 "2" 1002  1 2  9 17
17 1 10 15 "2" 1002  1 2  4 17
17 1 10 15 "2" 1002  2 2 70 17
17 1 10 15 "2" 1002  2 2 18 17
17 1 10 15 "2" 1002  2 1 17 17
17 1 10 15 "2" 1002  2 1 16 17
17 1 10 15 "2" 1002  2 2 15 17
17 1 10 15 "2" 1002  2 2 14 17
17 1 10 15 "2" 1002  3 1 33 17
17 1 10 15 "2" 1002  3 2 32 17
17 1 10 15 "2" 1002  3 1 14 17
17 1 10 15 "2" 1002  3 1 13 17
end
usia= age
b1r8=household serial number