Thanks a lot Nick.....
On Sat, 19 Jun 2004, Nick Cox wrote:
:It is the same problem really:
:
:egen count = count(varX1), by(state district)
:
:Nick
:[email protected]
:
:Rijo John
:
:> 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?
:
*
* 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/
