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
Related Posts with calculate percentage
Two way hbarHi everyone, I would like to ask if it is possible to produce the graph below using hbar command. I…
keeping the last observation onlyI have different individuals and want to keep the last observation only. any commands? …
Why generating the variable in logarithm form change the sign of correlation and scatterplot?Hello, first of all I apologize for this simple question. I try to do some tests to find a relations…
SUR Estimation - Equation residualsHi, I need to extract equationwise error terms of components of my SUR estimation. However by using…
Regression with moderation in StataHello everybody, I am a bit unsure about the construction of my regression and need some help. I hav…
Subscribe to:
Post Comments (Atom)
0 Response to calculate percentage
Post a Comment