[问答] 求助啊啊啊~请问各位要如何剔出年份数据不够的公司啊？在做面板数据的时候 [推广有奖]

11楼

lyly943 发表于 2012-7-26 17:34:49

wyfhdl 发表于 2012-7-25 20:41
tsset 就是对你数据里面的时间维度和横截面维度进行设置，t=var1 s=var2 这里的var1 / var2分别代表你的 ...

真的是太谢谢你了TT 就像是我的救命稻草啊55555 好热心太感动了。。。我没怎么在论坛发帖过原来还有评分呀。。我以后把分都给你真的是。。感激之情无以言表啊最近太着急了对这个论文。。
计量经济学导论木有找到电子版呢。。面板数据相关的。。。
我在按照这个http://wenku.baidu.com/view/8ce0e7ecf8c75fbfc77db2fa.html 第二十七页下面那里开始做恩。。可是做到第二步的xtsum的时候
我仿照他用命令xtsum cdebt ldebt etr1 etr2 etr3 size profitability ntds tang growth ownership

Variable | Mean Std. Dev. Min Max | Observations
-----------------+--------------------------------------------+----------------
type mismatch
r(109);

没有出现各个变量的描述性统计。。。不知道是什么原因呢。。。我数据大概是这样子的~~
CODE YEAR CDEBT LDEBT ETR1 ETR2 ETR3 SIZE PROFITABILITY NTDS TANG GROWTH OWNERSHIP
000002 2000 0.450479349 0.014229186 0.19343421 0.871190878 0.091963342 22.44999728 0.068930705 0.003014218 1 0.250871 0
000002 2001 0.469771696 0.040259688 0.240451807 -0.099525139 0.142528786 22.59243557 0.07690582 0.007710711 1 0.161133 0
000002 2002 0.37190959 0.203551351 0.237057322 0.946598372 0.137665024 22.82932768 0.062621442 0.004873704 1 0.267304 0
000002 2003 0.452303973 0.092177903 0.318812407 -0.17889545 0.190133471 23.0804376 0.078549708 0.005515545 1 0.285451 0
000002 2004 0.404505261 0.186366182 0.276787756 0.331564685 0.179759287 23.46632421 0.080859701 0.002415981 1 0.470918 0
000002 2005 0.493796353 0.114049699 0.272416042 0.643503398 0.178974728 23.81396242 0.090594002 0.001743865 1 0.41572 0.00064888
000002 2006 0.451162837 0.197243735 0.307656016 -0.359799616 0.214494773 24.60499287 0.072909125 0.001065359 1 1.205668 0.000552777
000002 2007 0.487279514 0.163466375 0.290472959 -0.222664126 0.215125192 25.32938026 0.079935544 0.001081259 1 1.005104 0.000252223
000002 2008 0.541391929 0.125315034 0.2410498 -49.26284926 0.146902171 25.50437542 0.058535216 0.000789766 1 0.19124 0.00236804
000002 2009 0.494578843 0.169295682 0.237993092 0.236392221 0.203221681 25.64767893 0.066791692 0.000695111 0.999404 0.15408 0.002197306
000002 2010 0.601244034 0.14195878 0.249188186 1.386136783 0.206519112 26.09686483 0.057712491 0.000445143 0.998266 0.567036 0.001761201
000004 2010 0.294231625 0.004342647 0.18301102 -0.377803489 0.094227325 19.03163819 0.131532121 0.021886086 0.934478 -0.200825 0
000004 2001 0.424687979 0.036034607 0.008380215 0.022630977 0.003532713 19.2182276 0.063544626 0.00471865 0.989232 -0.563153 2.8103E-06
000004 2002 0.481743739 0.047797048 0.13309784 -0.041530585 0.032041448 19.38999877 0.050661951 0.015567893 0.992838 0.187406 2.8103E-06
000004 2003 0.418100655 0.042038858 0.178373766 0.229285069 0.045260504 19.28725654 0.053842293 0.017907218 0.993767 -0.09764 2.8103E-06
000004 2004 0.378692475 0.049003537 -0.529931976 1.267035855 0.014009093 19.18274862 -0.004522506 0.023707473 0.985314 -0.099232 2.8103E-06
000004 2005 0.353711265 0.005132523 -0.045772741 0.073445934 0.034361341 18.864525 -0.113864638 0.011462859 0.981633 -0.27256 2.8103E-06
000004 2006 0.446499262 0.003915721 0.441582923 -0.352860788 0.156214162 19.13512276 0.03509659 0.018007303 0.940115 0.310748 0.00064899
000004 2007 0.36176551 0.062418078 -0.130278054 -0.147132197 0.067441699 18.95026489 -0.046233898 0.02335401 0.928268 -0.150082 0
000004 2008 0.428626955 0.063166456 -0.123253997 0.785716299 0.057362825 18.93834643 -0.054258062 0.024889575 0.92146 -0.011848 0
000004 2009 0.564382969 0.045984579 0.328545999 0.056913134 0.090488148 19.25581373 0.03501642 0.018570818 0.945831 0.373644 0
000004 2000 0.762100018 0 0.031652864 0.024494572 0.023796568 20.04639883 0.067010878 0.023146385 0.837214 0.523869 2.8103E-06
000005 2000 0.503183548 0.080666432 0 0 0 21.42669351 0.013335934 0.00740166 0.999996 -0.012014 0
000005 2001 0.356054865 0.076910484 0 0 0 21.3778359 -0.025722645 0.011739591 1 -0.033629 0
000005 2002 0.382044684 0.081294167 0 0 0 21.32240384 -0.047471951 0.015075361 1 -0.053924 0
000005 2003 0.396467673 0.083108604 0 0 0 21.30032987 -0.007414684 0.012280777 1 -0.006726 0
000005 2004 0.439400767 0.069951379 0 0 0 21.31692962 0.001136807 0.012444509 1 0.016738 0
000005 2005 0.531939781 0.066447639 0 0 0 21.22032107 -0.111244701 0.009809656 1 -0.092089 0
000005 2006 0.538132875 0 -1.538824531 4.83187366 0.108131597 21.14741778 -0.00546333 0.010873091 1 -0.069902 6.24389E-05

12楼

lyly943 发表于 2012-7-26 17:39:00

wyfhdl 发表于 2012-7-25 20:41
tsset 就是对你数据里面的时间维度和横截面维度进行设置，t=var1 s=var2 这里的var1 / var2分别代表你的 ...

然后我试着一个个分开做发现有的是不行的有的变量又可以不懂哪里不对呢
xtsum etr1

Variable       |    Mean Std. Dev.    Min       Max | Observations
-----------------+--------------------------------------------+----------------
etr1    overall |  .1149956 1.58479  -112.2016 59.46214 |    N = 9427
      between |          .4829889  -10.00929 5.597735 |    n =    857
      within  |             1.50948  -102.0773 53.9794 |    T =    11

. xtsum cdebt

Variable       |    Mean Std. Dev.    Min       Max | Observations
-----------------+--------------------------------------------+----------------
type mismatch
r(109);

. xtsum ldebt

Variable       |    Mean Std. Dev.    Min       Max | Observations
-----------------+--------------------------------------------+----------------
type mismatch
r(109);

. xtsum etr2

Variable       |    Mean Std. Dev.    Min       Max | Observations
-----------------+--------------------------------------------+----------------
type mismatch
r(109);

13楼

lyly943 发表于 2012-7-26 17:40:43

wyfhdl 发表于 2012-7-25 20:41
tsset 就是对你数据里面的时间维度和横截面维度进行设置，t=var1 s=var2 这里的var1 / var2分别代表你的 ...

啊对了！！我发现这些不对的数据在数据编辑窗口里都是红色。。黑色的变量则是可以描述性统计的这颜色代表了什么问题呢？

我又百度了下好像红色指的是字符不是数字什么的。。。然后试了试
destring cdebt,replace
cdebt contains nonnumeric characters; no replace
还是换不了 TT
我的数据是这样可是看上去都是数字嘛检查不出来有什么区别哎