I am using the below code to create summary statistics, however rename sd, p25, p75 to full form as Standard Deviation, 25th Percentile and 75th Percentile
Below is my data which is in panel strucure
Code:
bysort Industry: asdoc tabstat DACC REM_PROXY, stat(N mean sd p25 p75)
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str9 Ticker int Year str23 Industry float(REM_PROXY DACC) "TH:2S" 1995 "Industrials" . . "TH:2S" 1996 "Industrials" . . "TH:2S" 1997 "Industrials" . . "TH:2S" 1998 "Industrials" . . "TH:2S" 1999 "Industrials" . . "TH:2S" 2000 "Industrials" . . "TH:2S" 2001 "Industrials" . . "TH:2S" 2002 "Industrials" . . "TH:2S" 2003 "Industrials" . . "TH:2S" 2004 "Industrials" . . "TH:2S" 2005 "Industrials" . . "TH:2S" 2006 "Industrials" . . "TH:2S" 2007 "Industrials" . -.08454061 "TH:2S" 2008 "Industrials" .1827343 -.25864583 "TH:2S" 2009 "Industrials" -.07697056 .6085715 "TH:2S" 2010 "Industrials" -.02204012 .09650405 "TH:2S" 2011 "Industrials" .0666402 -.1017216 "TH:2S" 2012 "Industrials" -.22430627 .11378127 "TH:2S" 2013 "Industrials" .12869886 -.05965737 "TH:2S" 2014 "Industrials" .08143182 -.04307863 "TH:A" 1995 "Property & Construction" . . "TH:A" 1996 "Property & Construction" . . "TH:A" 1997 "Property & Construction" . . "TH:A" 1998 "Property & Construction" . . "TH:A" 1999 "Property & Construction" . . "TH:A" 2000 "Property & Construction" . . "TH:A" 2001 "Property & Construction" . . "TH:A" 2002 "Property & Construction" . . "TH:A" 2003 "Property & Construction" . . "TH:A" 2004 "Property & Construction" . .7635902 "TH:A" 2005 "Property & Construction" -.02616592 .06726224 "TH:A" 2006 "Property & Construction" .008145049 -.1024842 "TH:A" 2007 "Property & Construction" .0007321071 .09083974 "TH:A" 2008 "Property & Construction" .28484482 -.02267651 "TH:A" 2009 "Property & Construction" .0541619 -.15725097 "TH:A" 2010 "Property & Construction" -.29660693 .0957468 "TH:A" 2011 "Property & Construction" -.07530045 .032091457 "TH:A" 2012 "Property & Construction" .005613253 .1184249 "TH:A" 2013 "Property & Construction" -.11496368 .2663026 "TH:A" 2014 "Property & Construction" .0681241 .2288631 "TH:AA" 1995 "Industrials" .09536766 .1406714 "TH:AA" 1996 "Industrials" .013150566 .0505299 "TH:AA" 1997 "Industrials" -.007517671 .11710031 "TH:AA" 1998 "Industrials" -.04653792 .14672938 "TH:AA" 1999 "Industrials" -.04291132 -.05598317 "TH:AA" 2000 "Industrials" .01927743 -.01284377 "TH:AA" 2001 "Industrials" .031432163 .004790202 "TH:AA" 2002 "Industrials" -.11560664 .05033767 "TH:AA" 2003 "Industrials" -.09117547 .04497265 "TH:AA" 2004 "Industrials" -.03884211 -.12834519 "TH:AA" 2005 "Industrials" -.0020094477 .05263968 "TH:AA" 2006 "Industrials" -.08925325 .09047706 "TH:AA" 2007 "Industrials" -.04732592 .011825196 "TH:AA" 2008 "Industrials" . . "TH:AA" 2009 "Industrials" . . "TH:AA" 2010 "Industrials" . . "TH:AA" 2011 "Industrials" . . "TH:AA" 2012 "Industrials" . . "TH:AA" 2013 "Industrials" . . "TH:AA" 2014 "Industrials" . . "TH:AAV" 1995 "Services" . . "TH:AAV" 1996 "Services" . . "TH:AAV" 1997 "Services" . . "TH:AAV" 1998 "Services" . . "TH:AAV" 1999 "Services" . . "TH:AAV" 2000 "Services" . . "TH:AAV" 2001 "Services" . . "TH:AAV" 2002 "Services" . . "TH:AAV" 2003 "Services" . . "TH:AAV" 2004 "Services" . . "TH:AAV" 2005 "Services" . . "TH:AAV" 2006 "Services" . . "TH:AAV" 2007 "Services" . . "TH:AAV" 2008 "Services" . . "TH:AAV" 2009 "Services" . . "TH:AAV" 2010 "Services" . 1.0919831 "TH:AAV" 2011 "Services" -.2834487 .28426614 "TH:AAV" 2012 "Services" -.05159652 3.43393 "TH:AAV" 2013 "Services" .0460868 -.03935567 "TH:AAV" 2014 "Services" .0325668 -.017541166 "TH:ABICO" 1995 "Agro & Food Industry" . . "TH:ABICO" 1996 "Agro & Food Industry" . . "TH:ABICO" 1997 "Agro & Food Industry" . . "TH:ABICO" 1998 "Agro & Food Industry" . . "TH:ABICO" 1999 "Agro & Food Industry" . . "TH:ABICO" 2000 "Agro & Food Industry" . . "TH:ABICO" 2001 "Agro & Food Industry" . .3811837 "TH:ABICO" 2002 "Agro & Food Industry" -.05969042 -.068777665 "TH:ABICO" 2003 "Agro & Food Industry" -.013803639 -.1509448 "TH:ABICO" 2004 "Agro & Food Industry" -.01530991 -1.1338484 "TH:ABICO" 2005 "Agro & Food Industry" -.13842653 .6798385 "TH:ABICO" 2006 "Agro & Food Industry" -.001434846 -.013820863 "TH:ABICO" 2007 "Agro & Food Industry" .013482753 .066848315 "TH:ABICO" 2008 "Agro & Food Industry" .08086896 -.1630021 "TH:ABICO" 2009 "Agro & Food Industry" -.01393007 .1760944 "TH:ABICO" 2010 "Agro & Food Industry" .04895031 .027172344 "TH:ABICO" 2011 "Agro & Food Industry" -.3858832 .1821229 "TH:ABICO" 2012 "Agro & Food Industry" -.0327973 .2805742 "TH:ABICO" 2013 "Agro & Food Industry" .163937 .04285799 "TH:ABICO" 2014 "Agro & Food Industry" .10350908 .06678031 end format %ty Year
