Something like this?
sysuse auto,clear
levelsof rep, local(levels)
foreach l of local levels {
qui count if fore == 1 & rep == `l'
local n = r(N)
qui count if rep == `l'
local d = r(N)
local mytext "`mytext' 5 `l' "`n'/`d'" "
}
egen percent = mean(100 * foreign), by(rep78)
egen total = sum(1), by(rep78)
twoway bar percent rep78,barw(0.5) text(`mytext', box bc(white) )
ylabel(,angle(h)) ytitle(Percent Foreign)
Scott
On Wed, Apr 9, 2008 at 7:02 AM, Richard Goldstein
<[email protected]> wrote:
I want to produce a bar graph where the numeric variable is a 0/1 variable
(so the means are proportions) over a grouping variable -- that part is
easy. I would like to automatically add, either as a bar label or under the
group id (e.g., the "5", etc. if I typed -graph bar foreign, over(rep78)-
for the auto data), the numerator and denominator for this proportion (mean)
-- is there a way to do that?
Note that I do know that I can do this with graph edit; however, I need to
produce dozens of these graphs so I want an automatic way to do it.
Thanks,
Rich Goldstein
