The -fsum- command by Fred Wolfe is something that I have found very useful.
ssc install fsum
Bysort hid: fsum children, s(mean sum)
Carter
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Todd Swarthout
Sent: Thursday, January 18, 2007 4:44 AM
To: [email protected]
Subject: st: Sums and means within a table
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/
