try to:
bysort hid: sum children
where hid is the identification the household
Quoting Todd Swarthout <[email protected]>:
Hello. I have the following table:
tab Q1_1r�parti
Q1_1r�parti | Freq. Percent Cum.
------------+-----------------------------------
0 | 133 44.63 44.63
1 | 85 28.52 73.15
2 | 58 19.46 92.62
3 | 17 5.70 98.32
4 | 3 1.01 99.33
5 | 2 0.67 100.00
------------+-----------------------------------
Total | 298 100.00
This is the number of children in a household under 5 yrs of age.
For example, there are 133 households with 0 chilfren <5 yrs. Im
looking for a command that will allow me to sum the total number of
children in all 298 households and then to find the average number
per household.
A rather simple command I suspect
Thanks
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
