dear stata-users:
I have just started with stata graphics and have the following problem with the graph bar:
I have a database thant contains data on the existence of audit committees ("acexist") (in total there are 761 companies, 533 of them having an audit committee, 228 not). I would like to draw a graph bar that shows the increase in audit committee incidence over year.
Drawing a graph bar on the increase in the number of audit committees works fine; however, as the data from 2000 and 2001 are of poor quality I would like to have percentages of audit committee incidence over the years 2000-2004 (that is: 47.27% (2000); 71.76% (2001); 66.01% (2002); 73.08% (2003); 76.19% (2004)). neither of the following commands leads to the desired results:
. graph bar (sum) ecexist, over (year) percent
. graph bar (sum) ecexist, over (year) asyvar percentages
I am sure this is an easy question for you stata specialists out there! Many thanks for your help in advance!
Best,
Katy
By the way, the descriptives look as follows:
. by year: tabulate acexist
___________________________________________________________________________
-> year = 2000
acexist | Freq. Percent Cum.
------------+-----------------------------------
0 | 29 52.73 52.73
1 | 26 47.27 100.00
------------+-----------------------------------
Total | 55 100.00
___________________________________________________________________________
-> year = 2001
acexist | Freq. Percent Cum.
------------+-----------------------------------
0 | 24 28.24 28.24
1 | 61 71.76 100.00
------------+-----------------------------------
Total | 85 100.00
___________________________________________________________________________
-> year = 2002
acexist | Freq. Percent Cum.
------------+-----------------------------------
0 | 69 33.99 33.99
1 | 134 66.01 100.00
------------+-----------------------------------
Total | 203 100.00
___________________________________________________________________________
-> year = 2003
acexist | Freq. Percent Cum.
------------+-----------------------------------
0 | 56 26.92 26.92
1 | 152 73.08 100.00
------------+-----------------------------------
Total | 208 100.00
___________________________________________________________________________
-> year = 2004
acexist | Freq. Percent Cum.
------------+-----------------------------------
0 | 50 23.81 23.81
1 | 160 76.19 100.00
------------+-----------------------------------
Total | 210 100.00
