Try this:
**********
sysuse auto, clear
*tag the groups
egen groups=group(f rep)
levelsof groups, loc(gr)
*counts go into mycount var
g mycounts=.
*loop over the levels of the groups
foreach lev of loc gr{
count if gr==`lev'
replace mycounts=r(N) if gr==`lev'
}
*lets see what happened
sort f rep
l f re gro myco, sepby(f rep) noo
table rep f, c(freq mean myc)
**********
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Ashim Kapoor
Sent: Thursday, September 18, 2008 10:48 AM
To: [email protected]
Subject: Re: st: RE: use of count.
Can you please clarify how I can do this Martin ?
> You probably cannot replace with the string count: if at all, you would
have
> to count first and the replace with the return value "r(N)".
Thank you,
Ashim.
On Thu, Sep 18, 2008 at 1:14 PM, Martin Weiss <[email protected]> wrote:
> You probably cannot replace with the string count: if at all, you would
have
> to count first and the replace with the return value "r(N)".
> Also try this:
>
> **********
> u auto, clear
> egen float mygroups = group(f rep78)
> by mygroups, sort : egen float mycount = count(mygroup)
> **********
>
>
> HTH
> Martin
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Ashim Kapoor
> Sent: Thursday, September 18, 2008 9:34 AM
> To: [email protected]
> Subject: st: use of count.
>
> Hello everyone,
>
> I have a question :
>
> I want to do :
>
> bysort state cnum cname : replace no_of_cand_in_state=count
>
> This does not work. could someone please tell me how do I fix this ?
>
> Thank you,
> Ashim.
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
