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
Changing variable value across cross-sectional units in panel data if criteria is metI have panel data in which my cross-sectional units are farms. I am correcting a variable for the ye…
Generating Variables Acc. to Multiple Conditions And Earliest OccurrenceI am working with a dataset that contains names, the frequency of a name according to gender, and th…
Distance between observations in different data basesHi, I have two data bases (1 & 2). I can compare longitude and latitude between them but nothing…
Chi Square Test for Suvery Weighted DataHello Everyone, I am trying to conduct Chi-Square test on proportion using the survey data. I have s…
Combining bar graphs from different binary variablesDear all, I'm trying to get a combined bar chart for an overview of the proportions from three diff…
Subscribe to:
Post Comments (Atom)
0 Response to calculate percentage
Post a Comment