Hello, everyone,
in my panel data I would like to calculate the percentage of restatements during the years. for example in 2001 it would look like: if Restatement==1 then 1371/34510
tabulate Restatement Year
Restatemen | Year
t | 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 | Total
-----------+-------------------------------------------------------------------------------------------------------------------------+----------
0 | 33,139 32,118 31,632 31,062 30,630 30,201 29,032 26,766 27,444 26,896 25,918 | 475,259
1 | 1,371 1,502 1,450 1,398 1,243 1,246 1,862 3,414 1,537 895 812 | 22,591
-----------+-------------------------------------------------------------------------------------------------------------------------+----------
Total | 34,510 33,620 33,082 32,460 31,873 31,447 30,894 30,180 28,981 27,791 26,730 | 497,850
0 Response to calculate percentage
Post a Comment