Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Count


From   Rijo John <rijo@igidr.ac.in>
To   Statalist <statalist@hsphsun2.harvard.edu>
Subject   st: Count
Date   Sat, 19 Jun 2004 00:29:38 +0530 (IST)

Dear Stat users,

 I have a problem in counting the observatios over groups and subgroups.
I have 20 groups in variable "state" and 3 subgroups each called
"district" within "state". Now I have a set of variables varX1 varX2 varX3
whose observations are to be counted by state(district)
Finally I should get some thing like :
for variable var1:

state      district1       district2        district3
1         count of varX1  count of varX1  count of varX1
2
3
4
.
.
.
20

Similiarly for var2, var3 etc...

when I had only one group (state) I use to do it as follows:

local item "X1 X2 X3"
foreach X of local item {
	egen No`X' = count(var`X'), by(state)
	}
table state, c(m varX1 m varX2 m varX3) row

Now with an additional subgroup how can I do this?

Thanks in advance for your advice.

Rijo John.

*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index