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
Necessary co-variate omitted due to collinearityHi everyone, I had a quick question. I am new to Stata, so please forgive me if this question seems…
Retrieving data from online archive database and making it ready for STATA (CEDA Archive database) THERE MUST BE SOMEONE HERE WHO IS ABLE TO DO THIS Hi everyone, I'm in a bit of a pickle. I have …
Export adjusted ratios from dstdize commandDear all, Really appreciate if someone could kindly help me. I'm using Code: dstdize command to ca…
Problem with number of instrument with xtabond2Hello everyone, I am just new to managing panel series and I am working on the investigation of fina…
Whether coefficients of before clustering and after clustering in using reg command is strange?Hi all, Today I run a simple reg for a panel dataset with a panel of units and time periods , I con…
Subscribe to:
Post Comments (Atom)
0 Response to calculate percentage
Post a Comment