Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From   "Martin Weiss" <[email protected]>
To   <[email protected]>
Subject   st: AW: AW: Create a flag variable for 10 most frequent values
Date   Mon, 16 Nov 2009 22:38:42 +0100

<> 


Forget this solution, I read "highest" instead of "most frequent". Sorry!
Hopefully this is still helpful to you!



HTH
Martin


-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Martin Weiss
Gesendet: Montag, 16. November 2009 22:33
An: [email protected]
Betreff: st: AW: Create a flag variable for 10 most frequent values


<> 



*************
clear*

//construct data
set obs 10000
gen dx=_n
//5000 unique values
sample 5000, count
 
//sort on dx
sort dx
//give the last 10 values a "1"
gen byte flag=_n>4990
//let`s see
l in -20/l
//tabulation of "flag"
ta flag
//properties of "dx" for flag "1" or "0"
table flag, c(freq mean dx min dx max dx)
*************



HTH
Martin

-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Cohen, Elan
Gesendet: Montag, 16. November 2009 22:25
An: '[email protected]'
Betreff: st: Create a flag variable for 10 most frequent values

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/


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



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