Hello everyone, I have the following dataset:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long datadate str58 conm str5 ffinds float(tobinQ DEratio IKratio) double RET_sum 14609 "1-800 CONTACTS INC" "Shops" 8.508272 .0016041923 .8433363 . 14975 "1-800 CONTACTS INC" "Shops" 14.222518 .2337988 .3587759 . 15340 "1-800 CONTACTS INC" "Shops" 4.3282104 .5273439 .4119069 . 15705 "1-800 CONTACTS INC" "Shops" 6.347464 18.126167 .1174001 . 16070 "1-800 CONTACTS INC" "Shops" 4.802786 14.811702 .15626185 . 16436 "1-800 CONTACTS INC" "Shops" 4.234757 22.7007 .13556117 . 16801 "1-800 CONTACTS INC" "Shops" 2.8556266 30.298553 .28288168 . 17166 "1-800 CONTACTS INC" "Shops" 3.551534 34.480396 .5602976 . 15156 "1-800-FLOWERS.COM" "Shops" 6.739181 12.543878 . . 15521 "1-800-FLOWERS.COM" "Shops" 3.5733285 12.269454 .3096153 . 15886 "1-800-FLOWERS.COM" "Shops" 5.024516 9.146034 .2579355 . 16252 "1-800-FLOWERS.COM" "Shops" 3.8399935 6.078213 .24185115 . 16617 "1-800-FLOWERS.COM" "Shops" 3.405308 3.360937 .20953363 . 16982 "1-800-FLOWERS.COM" "Shops" 2.715548 78.11663 .2232304 . 17347 "1-800-FLOWERS.COM" "Shops" 3.143088 68.0504 .3275363 . 17713 "1-800-FLOWERS.COM" "Shops" 2.2914743 55.30567 . . 18078 "1-800-FLOWERS.COM" "Shops" 2.0553632 70.68497 . . 18443 "1-800-FLOWERS.COM" "Shops" 2.1889625 45.8186 . . 18808 "1-800-FLOWERS.COM" "Shops" 2.1010947 29.36639 . . 19174 "1-800-FLOWERS.COM" "Shops" 2.505273 13.59741 .3496476 . 19539 "1-800-FLOWERS.COM" "Shops" 3.0585864 0 . . 19904 "1-800-FLOWERS.COM" "Shops" 3.6604996 .001872281 .3332502 . 20269 "1-800-FLOWERS.COM" "Shops" 2.443491 117.63277 .1351264 . 20635 "1-800-FLOWERS.COM" "Shops" 2.927234 98.04977 .19007714 . 21000 "1-800-FLOWERS.COM" "Shops" 2.833774 101.40247 .21029738 . 21365 "1-800-FLOWERS.COM" "Shops" 2.982154 92.29896 . . 21730 "1-800-FLOWERS.COM" "Shops" 3.153008 91.98759 . . 9070 "1MAGE SOFTWARE INC" "BusEq" 2.251663 .1840396 .25270757 . 9435 "1MAGE SOFTWARE INC" "BusEq" 2.3038278 .21721105 .7819383 . 9800 "1MAGE SOFTWARE INC" "BusEq" 1.848045 1.2883546 .08600337 . 10165 "1MAGE SOFTWARE INC" "BusEq" 1.5916607 1.3494127 .8574514 . 10531 "1MAGE SOFTWARE INC" "BusEq" 1.6125416 .59322387 .1642857 . 10957 "1MAGE SOFTWARE INC" "BusEq" 1.522075 .6392407 . . 20453 "22ND CENTURY GROUP INC" "Hlth" 7.049687 .33434495 -.163928 .15926671214401722 20819 "22ND CENTURY GROUP INC" "Hlth" 5.456799 .012657188 .015195072 . 21184 "22ND CENTURY GROUP INC" "Hlth" 6.284982 0 .05940893 . 21549 "22ND CENTURY GROUP INC" "Hlth" 5.937014 .8576661 .3547991 .02921333909034729 21914 "22ND CENTURY GROUP INC" "Hlth" 4.1072836 .6869087 .12063407 -.47212739288806915 14609 "24/7 REAL MEDIA INC" "BusEq" 4.2859573 .01312318 .08389352 . 14975 "24/7 REAL MEDIA INC" "BusEq" 1.8573456 .15447597 .4089422 . 15340 "24/7 REAL MEDIA INC" "BusEq" 1.4906782 4.6158705 4.481135 . 15705 "24/7 REAL MEDIA INC" "BusEq" 1.3313392 7.948827 .56318957 . 16070 "24/7 REAL MEDIA INC" "BusEq" 4.4282284 13.33908 . . 16436 "24/7 REAL MEDIA INC" "BusEq" 3.211396 6.573282 . . 16801 "24/7 REAL MEDIA INC" "BusEq" 3.927317 .20012684 . . 17166 "24/7 REAL MEDIA INC" "BusEq" 4.136897 7.848601 .7737859 . 20453 "2U INC" "BusEq" 7.39108 0 .4678888 . 20819 "2U INC" "BusEq" 7.617836 0 .26263145 . 21184 "2U INC" "BusEq" 8.851855 3.5 .15590663 . 21549 "2U INC" "BusEq" 5.451736 3.5 .5223044 . 21914 "2U INC" "BusEq" 2.888563 313.6051 .11872056 . 9282 "3COM CORP" "BusEq" 4.935338 .9129182 .4703667 .4407764673233032 9647 "3COM CORP" "BusEq" 5.595801 .726997 .6072411 . 10012 "3COM CORP" "BusEq" 4.6675944 .1754407 .2220039 . 10378 "3COM CORP" "BusEq" 4.624487 2.2324364 .23489933 -.018478821963071823 10743 "3COM CORP" "BusEq" 4.368012 3.362248 .4820495 .4984411816112697 11108 "3COM CORP" "BusEq" 3.156491 .832413 .48975965 -.47400884702801704 11473 "3COM CORP" "BusEq" 2.509657 .3079429 .51198757 -.23798490595072508 11839 "3COM CORP" "BusEq" 2.733446 1.484548 .498294 . 12204 "3COM CORP" "BusEq" . .6139534 .38935345 . 12569 "3COM CORP" "BusEq" . 1.0597168 .3322786 .6975756268948317 12934 "3COM CORP" "BusEq" 5.804919 111.09442 .3371167 1.0902648130431771 13300 "3COM CORP" "BusEq" 6.812934 115.492 .3090792 .48784300684928894 13665 "3COM CORP" "BusEq" 7.460834 115.391 .4769643 . 14030 "3COM CORP" "BusEq" 4.77258 35.88228 .2885527 . 14395 "3COM CORP" "BusEq" 5.288676 30.40956 .5516904 . 14761 "3COM CORP" "BusEq" 4.192189 14.743576 .3299505 .9779941635206342 15126 "3COM CORP" "BusEq" 2.573204 2.385131 .2986703 .04079020023345947 15491 "3COM CORP" "BusEq" 2.674997 68.45597 -.1003159 .16816721856594086 15856 "3COM CORP" "BusEq" 2.659018 .000201327 1.3489288 . 16222 "3COM CORP" "BusEq" 3.585532 0 -.7688125 . 16587 "3COM CORP" "BusEq" . 0 -1.7090818 -.5052792765200138 16952 "3COM CORP" "BusEq" . 0 -.3386751 .2843475865665823 17317 "3COM CORP" "BusEq" . 336.0816 .22762227 .07981697097420692 17683 "3COM CORP" "BusEq" . 253.04823 -.1518761 . 18048 "3COM CORP" "BusEq" . 152.04315 .4197991 . 12783 "3D SYSTEMS CORP" "Manuf" 4.698982 0 .2170798 . 13148 "3D SYSTEMS CORP" "Manuf" 5.056679 0 .27879152 . 13514 "3D SYSTEMS CORP" "Manuf" 3.314967 4.801455 .3095765 . 13879 "3D SYSTEMS CORP" "Manuf" 2.481076 4.7064705 .4745502 . 14244 "3D SYSTEMS CORP" "Manuf" 2.597999 4.6065025 .365897 . 14609 "3D SYSTEMS CORP" "Manuf" 2.72945 4.4968452 .22086796 . 14975 "3D SYSTEMS CORP" "Manuf" 2.999115 4.3766713 .3407656 . 15340 "3D SYSTEMS CORP" "Manuf" 2.632842 25.756485 .1083184 . 15705 "3D SYSTEMS CORP" "Manuf" 2.2033381 14.306316 .21624616 . 16070 "3D SYSTEMS CORP" "Manuf" 2.270365 36.63218 .2276735 . 16436 "3D SYSTEMS CORP" "Manuf" 3.58719 26.45164 .08642105 . 16801 "3D SYSTEMS CORP" "Manuf" 3.2788224 26.15136 .0641953 . 17166 "3D SYSTEMS CORP" "Manuf" 3.2492914 24.368994 .07894626 . 17531 "3D SYSTEMS CORP" "Manuf" 3.6713 8.696465 .461863 . 17897 "3D SYSTEMS CORP" "Manuf" 2.828813 8.4990835 .03842639 . 18262 "3D SYSTEMS CORP" "Manuf" 3.4015944 8.256035 . . 18627 "3D SYSTEMS CORP" "Manuf" . 8.056683 . . 18992 "3D SYSTEMS CORP" "Manuf" . 138.71664 . . 19358 "3D SYSTEMS CORP" "Manuf" 6.428952 87.97437 . . 19723 "3D SYSTEMS CORP" "Manuf" 10.604547 18.693201 .07131481 . 20088 "3D SYSTEMS CORP" "Manuf" 4.269652 8.905529 .06216339 . 20453 "3D SYSTEMS CORP" "Manuf" 2.846095 8.187806 .2642828 . 20819 "3D SYSTEMS CORP" "Manuf" 3.54067 7.587908 .28006452 . 21184 "3D SYSTEMS CORP" "Manuf" 2.8062286 7.079041 .1662924 . end format %d datadate
Then I run the tabstat command:
Code:
tabstat tobinQ DEratio IKratio RET_sum, statistics( count mean median ) by(ffinds)
Code:
ffinds | tobinQ DEratio IKratio RET_sum
-------+----------------------------------------
BusEq | 37 44 40 14
| 3.957182 36.64331 .3934658 .2521618
| 3.927317 1.41698 .3346976 .2262574
-------+----------------------------------------
Hlth | 5 5 5 3
| 5.767153 .3783154 .0772218 -.0945491
| 5.937014 .334345 .0594089 .0292133
-------+----------------------------------------
Manuf | 22 24 20 0
| 3.704453 20.30449 .2166868 .
| 3.264057 8.377559 .2189739 .
-------+----------------------------------------
Shops | 27 27 19 0
| 4.055298 38.03305 .2976064 .
| 3.153008 22.7007 .2579355 .
-------+----------------------------------------
Total | 91 100 84 17
| 4.024643 31.28397 .310869 .1909775
| 3.405308 7.333474 .2715372 .1592667
------------------------------------------------Is this possible? And if not, what would be your advise to obtain the similar result?
0 Response to Combine different tabstat results in one
Post a Comment