Re: st: Create a flag variable for 10 most frequent values

[Jeph Herrin <junk@spandrel.net>]

how about

 bys dx  : gen num=_N
 bys num : gen tmp= num if _n==1
 gsort -tmp
 gen top10num=tmp[10]
 gen byte top10=num>=top10num
 drop tmp top10num

?

J




Cohen, Elan wrote:
> Hi all,
>
> I have a string variable dx that represents a patient's diagnosis
> (about 5,000 unique values).  I'd like to create a "top 10 flag" that
> equals 1 if dx is one of the top 10 most frequent diagnoses and 0
> otherwise.
>
> I'm not even sure where to begin.  If someone could point me in the
> right direction, I'd be grateful.  Stata 10, Windows XP
>
> Thank you,
>
> - Elan
>
> * *   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/