Although for any reasonable (i.e. equal) binning, doing it directly is
probably easiest:
. sysuse auto
. gen mpg2 = string(4 * floor(mpg/4)) + "-"
. tab mpg2
mpg2 | Freq. Percent Cum.
------------+-----------------------------------
12- | 10 13.51 13.51
16- | 25 33.78 47.30
20- | 16 21.62 68.92
24- | 12 16.22 85.14
28- | 7 9.46 94.59
32- | 3 4.05 98.65
40- | 1 1.35 100.00
------------+-----------------------------------
Total | 74 100.00
I suggested some time ago to StataCorp that -floor()- (and, for that
matter, -ceil()-) could take an optional second argument: thus
-floor(mpg, 4)- would be 4 * floor(mpg/4), as above.
Nick
[email protected]
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Nick Cox
Sent: 23 January 2008 19:07
To: [email protected]
Subject: st: FW: Interval Tabbing?
When I said -tabcount-, I really meant -tabcond-.
-----Original Message-----
From: Nick Cox
Sent: 23 January 2008 19:04
To: '[email protected]'
Subject: RE: Interval Tabbing?
At worst, this is two (or three) steps,
1. create categories
(2. label them nicely)
3. tabulate
But it can be compressed to one step:
. findit tabcount
. ssc inst tabcount
The help file for -tabcount- also has some examples of solutions that
don't entail using -tabcount-.
Nick
[email protected]
Rachel
What I'm looking to do is put a histogram in table form: That is, I'd
like a table showing me how many (and what percentage) of a variable
falls within intervals whose width I specify.
So for example, if X has values 2,3,5,7, and I specified an interval
of width for, the resulting table would look something like:
X range Perc
0-4 50%
>4-8 50%
8-12 0%
Is there any Stata command (or user-written module) that can 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/
*
* 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/
