I'm dealing with panel data and want to summarize statistics per category (of credit ratings).
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input float(abCFO abPROD abDEXP DSIZE DLEV DBTM DROA DMKTCAP) str10 rating
.0008356422 .0209654 -.04120781 1.0675211 .09522586 -.020025164 -.005955193 1.0338011 "A"
.04126537 .11411357 -.2075455 1.3290644 -.1180799 .3128669 -.009585299 1.1216774 "A"
.05412142 -.0023708344 -.09028757 .3537397 .04073374 -.09376688 .005242527 .4053659 "A"
-.06789315 .01299727 .017316878 0 0 0 0 0 "A"
.03516224 .014169693 -.03243965 .7051764 -.005756766 -.05200678 .0019333176 .711113 "A"
.02273792 -.3003528 .24185824 -.436142 -.018526852 -.3142054 .0281377 .19754696 "A"
.02906984 .01651007 -.013555497 0 0 0 0 0 "A"
-.008219257 -.026155293 -.016452044 .8714962 -.1100984 .09946762 .013385184 1.0990686 "A"
.015034273 -.007772714 -.0014599115 0 0 0 0 0 "A"
.01064366 .01884005 .015010998 .6108894 .05213448 .03925359 -.04097756 .28347492 "A"
-.03769853 .08655733 -.018181875 0 0 0 0 0 "A"
.002282584 -.05673644 -.01677883 -.6284599 .021837205 .11429861 .0022028554 -.7300711 "A"
.01605764 .007799983 -.04779823 0 0 0 0 0 "A"
-.05145291 .034692526 -.019910425 0 0 0 0 0 "A"
.019588366 -.022314847 .0537526 0 0 0 0 0 "A"
.5352056 -.1746373 .1034913 1.4397526 -.12459834 -.3247728 .06580749 2.2632608 "A"
-.5205612 .04782104 -.12157464 .8937941 .0620793 -.8088898 -.009963654 1.563591 "A"
1.383108 15.051348 .21882486 2.3815413 -.022225797 -.067750186 .012041256 2.5519066 "A"
-.05585086 -.08561337 .2999828 .7043247 -.07351613 -.14118776 .0102163 1.0763502 "A"
-.031702437 -.030215085 -.011980027 -.1159935 .0003680885 .012074515 .02267707 -.1801214 "A"
.22149777 .007992268 -.11340237 1.2447286 -.10326292 -.16692924 .1325304 1.7184153 "A"
.010136515 -.031345695 -.002566412 .2066736 .03281617 -.07913816 -.016860146 .29421997 "A"
-.0008031726 .00295949 .0009338856 0 0 0 0 0 "A"
.05672702 .15594888 -.09790777 -.5628605 -.08298059 .2550441 -.026939005 -.6609955 "A"
4.065048 -.4410348 6.519212 2.6107664 -.08981347 -.033990264 .06825436 3.130191 "A"
.0013318062 .0019093156 .003956169 0 0 0 0 0 "A"
.015214458 .001820922 .002174735 0 0 0 0 0 "A"
-.0858939 -.005479097 -.017050624 .805624 .008312494 -.02377057 -.017139435 .7116251 "A"
-.003535643 .0008456111 -.006619245 0 0 0 0 0 "A"
-.013042033 .05763382 -.07504414 -.28429842 -.073293455 -.01555115 .031368412 -.020739555 "A"
-.005106941 -.0003865045 -.005620822 .14349842 -.15960807 -.05899999 .04943158 .6170788 "A"
.15186906 -.14246893 -.02312088 1.414975 -.16248295 -.23669094 .032986898 1.729827 "A"
.012504876 -.008911222 .014210224 0 0 0 0 0 "A"
-.006002272 -.0492735 -.05302888 -.4925308 .1150909 -.03783548 .04110579 -.55949306 "A"
-.3204973 .6066685 -.16515303 2.0650449 .017856106 -.3805348 .05397183 2.800459 "A"
.0028551295 -.01931976 -.006467238 -.6234713 -.12063618 -.24762145 .05819488 .05962086 "A"
-.15009254 .11929631 .024970055 .08544827 -.05493088 -.04747084 -.006268077 .4955101 "A"
-.007557273 -.001894951 .02478403 0 0 0 0 0 "A"
.0003720671 -.0248881 -.03295061 .2636423 .03391564 -.09878263 .016890325 .4170308 "A"
.15458107 -.4208779 -.00819011 .8457394 -.008284703 -.1861056 .08795613 1.5672665 "A"
-.06220771 -.4356552 -.0003861114 0 0 0 0 0 "A"
.6288794 11.155063 .1858667 2.6107664 -.2052954 .3386117 .0013565645 3.232208 "A"
.2098929 -.24874997 .13575831 -.42136765 -.025275767 .11055869 -.2325881 -.16615915 "A"
.02352494 -.1229782 .03964202 .4956236 -.069366604 -.24916805 .0548659 1.2631798 "A"
.014861077 .006323397 -.017629743 0 0 0 0 0 "A"
-.012095168 .004829198 .0004029274 -.07305241 .011497766 -.04982682 .018362954 .03733635 "A"
-.07350977 -1.294515 -.27100414 -.1960354 -.0590487 .466735 .08753496 .9801435 "A"
.06479162 -.014288187 -.035856374 .03793049 -.02283114 .28392336 -.00679981 .06511593 "A"
.0898911 .027997136 -.17297468 1.0080242 .011632174 -.09668097 .04373648 1.506379 "A"
.029090397 -.12285227 -.032613724 2.0186138 .12294215 -.12049067 -.03859614 1.3814163 "A"
-.06873721 -.11470234 .029512286 1.5590916 .11953676 -.56961507 .012153603 2.7031994 "A"
.0015919805 -.034819186 .25707626 .058815 -.04611056 -.09457007 .036897853 .3781643 "A"
.00093274 .005595282 -.0292524 .10843086 -.14261137 .06788117 -.015993588 -.019307137 "A"
.03901547 -.14219153 -.47010255 .3034983 .006643087 -.1684 -.003110811 .9891348 "A"
-.018318448 .010679606 -.0016479343 -.57105494 .04912265 -.034465 .00723815 -.303587 "A"
.26985353 .16105187 .4707473 1.8921747 -.2081337 .11422935 .02254638 1.8579702 "A"
-.005359652 .03072861 -.004871659 -.7092295 -.11220533 -.0821746 .04187417 -.2493067 "A"
-.023301035 -.0041386485 .012192875 0 0 0 0 0 "A"
.04949512 -.1561916 .08938599 .06013489 -.1143501 -.08023608 -.2325881 .6703806 "A"
-.01436942 .184457 -.032435283 .870676 -.05707991 -.11407918 .005377695 1.0769653 "A"
.05515257 .01990676 -.004722625 .06156445 -.02582699 -.02527219 .02262192 .12867355 "A"
.015558764 -.09322359 .002729595 -.6140423 -.07559586 -.2080527 .06483234 .06052971 "A"
.0350079 -.03337896 .025618345 0 0 0 0 0 "A"
.002475947 -.10662834 .002184838 -.3838196 -.05461299 -.1719733 .06384196 .21448326 "A"
-.04412465 -.18742947 .50620687 -.13668633 -.16536823 .05545654 -.034425512 -.273036 "A"
-.00180055 .01974368 -.0041654967 .8757238 -.010082394 .027917564 -.009779492 .8622069 "A"
.09681302 -.13990852 .01157169 .8020191 -.04014236 -.05426004 .05594094 1.1844053 "A"
.05664325 -.2295618 -.00006067753 1.855895 .11774266 -.1383622 -.024673285 1.5912905 "A"
.6840518 -.5675211 1.02707 2.1980247 -.26134452 -.02193013 .08406796 3.1024075 "A"
1.528804 8.182507 2.610342 2.585969 -.03001055 -.03053251 -.033078484 2.3776035 "A"
-.04574649 -.099018 -.016450942 -.7864103 -.19859247 -.03853482 .08468947 -.2097597 "A"
.03145185 .026230097 .01457572 .6023769 .064970374 -.24634096 .04673266 .8368998 "A"
.007426903 -.12688667 .091268 .20284843 -.09636705 -.16220093 .05945984 .7945929 "A"
-.0527891 -.04278681 -.20756406 -1.2957058 -.03106573 -.1642542 .030025885 -.4209194 "A"
-.021736294 .1927209 -.0931441 .5419588 .006153762 .01554194 .05797769 .7128754 "A"
.05428351 -.029087394 -.02094871 0 0 0 0 0 "A"
-.03914413 .12011677 -.02894477 .799284 -.06337117 -.21397233 .00038175285 .8705263 "A"
-.05919284 .0005379077 -.22089574 -.3100538 .0817831 -.05888341 .019549936 -.3823338 "A"
-.3511926 .25872612 -.11008978 1.1532726 -.13010441 -1.75839 .06138948 2.540582 "A"
1.2319677 2.1334038 .4698467 2.047367 .07085404 -.3441069 -.000774052 2.370553 "A"
-.02939762 -.1820482 -.2207026 -1.0811806 -.02847527 -.12740248 -.02501364 -.4062376 "A"
.7960979 1.079081 1.217936 1.3663883 -.21769533 -.1818109 .08663443 2.234949 "A"
-.006156363 .016386092 .0016980767 .5608988 -.04387307 -.07724735 .1286043 1.3332567 "A"
-.064265266 -.0406478 -.21026033 -.9889154 .01815477 -.05547068 .007833689 -.57637787 "A"
.02082923 -.00505513 -.011248618 0 0 0 0 0 "A"
.0012223423 -.10457492 .014408767 1.1001778 -.04852214 .05529368 .03234246 1.582531 "A"
-.02684657 -.06120563 .019127995 .04639244 -.14851223 .10611515 -.013167985 .15285683 "A"
-.006203264 .00979209 -.04708833 .2309699 -.01061432 -.11637849 .02230383 .4286661 "A"
-.018750176 .015574634 .004465133 .0840025 .08309455 -.009600505 -.01997224 -.11210918 "A"
-.015592322 .04403156 .01322055 -.04160309 .08806102 .012019545 -.02980508 -.3972139 "A"
.01528483 -.006228779 .02451776 0 0 0 0 0 "A"
-.00676385 -.1510534 -.01972099 -.4460049 .14370497 -.024659857 -.022344027 -.6619034 "A"
.04294263 -.003376007 -.008284733 0 0 0 0 0 "A"
.004836034 -.029315114 -.018319458 -.4790058 -.05318485 -.3411892 .032577105 .1502838 "A"
.022219537 .5413217 -.2799912 -.11668396 -.1535708 1.040497 .019435655 .7593822 "A"
.0004287735 .00006824732 -.014224023 0 0 0 0 0 "A"
3.276752 .8972087 4.965589 2.5211096 -.26134452 .06412527 .18672 3.2333994 "A"
-.008098744 .016093373 -.005147368 0 0 0 0 0 "A"
-.10295901 .006470382 .07685748 .25371933 .02636473 -.14592972 .003463462 .5454149 "A"
-.0706507 .26448023 -.3060949 -.31894875 .0783524 -.025341675 -.007336631 -.55567074 "A"
endArray
I have currently tried this command:
bys rating: asdoc tabstat abCFO abPROD abDEXP DSIZE DLEV DBTM DROA DMKTCAP, replace stat(N mean median sd) varwidth(14) format(%9.3f) title(Descriptive statistics per credit rating category )
But that does not generate the format I want. Also, I would like to change the order in which the ratings are displayed, I would want to have the categories go like: AAA AA A BBB BB B CCC, but now it does A AA AAA B BB BBB CCC .
Can someone help me with this?
0 Response to summary statistics per category
Post a Comment