Do you mean something like:
. keep if county > 5
or
. keep if county > 5 & county <.
Best,
Alan
On 4/16/07, Michael McCulloch <mm@pinest.org> wrote:
> Dear Statalist members,
> I would like to choose records in which the number of observations in
> a field, here named county, is greater than 5. Below is a tabulation
> of county. I've examined the help file for -count-, but this doesn't
> seem to suit my needs. Any guidance would be appreciated. Thank you.
>
> . tab county
>
> COUNTY OF |
> RESIDENCE @ |
> DX | Freq. Percent Cum.
> ------------+-----------------------------------
> 0 | 34 0.61 0.61
> 1 | 1,055 18.78 19.39
> 3 | 23 0.41 19.80
> 4 | 11 0.20 19.99
> 5 | 8 0.14 20.14
> 6 | 3 0.05 20.19
> 7 | 656 11.68 31.87
> 9 | 53 0.94 32.81
> 10 | 6 0.11 32.92
> 12 | 4 0.07 32.99
> 15 | 1 0.02 33.01
> 17 | 38 0.68 33.68
> 18 | 1 0.02 33.70
> 19 | 2 0.04 33.74
> 20 | 2 0.04 33.77
> 21 | 174 3.10 36.87
> 22 | 1 0.02 36.89
> 23 | 10 0.18 37.07
> 27 | 6 0.11 37.17
> 28 | 104 1.85 39.02
> 29 | 27 0.48 39.51
> 31 | 102 1.82 41.32
> 32 | 1 0.02 41.34
> 33 | 2 0.04 41.37
> 34 | 855 15.22 56.60
> 35 | 6 0.11 56.70
> 36 | 1 0.02 56.72
> 37 | 2 0.04 56.76
> 38 | 445 7.92 64.68
> 39 | 85 1.51 66.19
> 40 | 2 0.04 66.23
> 41 | 430 7.66 73.88
> 43 | 699 12.44 86.33
> 44 | 27 0.48 86.81
> 45 | 5 0.09 86.90
> 48 | 362 6.44 93.34
> 49 | 255 4.54 97.88
> 50 | 22 0.39 98.27
> 51 | 7 0.12 98.40
> 52 | 2 0.04 98.43
> 53 | 1 0.02 98.45
> 54 | 3 0.05 98.50
> 55 | 13 0.23 98.74
> 57 | 54 0.96 99.70
> 58 | 12 0.21 99.91
> 230 | 1 0.02 99.93
> 641 | 1 0.02 99.95
> 999 | 3 0.05 100.00
> ------------+-----------------------------------
> Total | 5,617 100.00
> *
> * 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/
>
*
* 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/
