经管之家App
让优质教育人人可得
立即打开
全部版块
我的主页
›
论坛
›
计量经济学与统计论坛 五区
›
计量经济学与统计软件
›
Stata专版
非平衡面板数据如何做2SLS?
楼主
rongyan123
1740
2
收藏
2020-02-01
global X1 "sPRO cPRO iPRO lPRO roePRO yPRO ciPRO"
global X "size capital inventory lev roe"
xtset IDID year
xtreg RPRO PRO audit aPRO $X $X1 i.year i.city,r
这是基本回归,RPRO是被解释变量,PRO audit aPRO是解释变量(aPRO是PRO和audit的乘积,audit是一个虚拟变量),主要是看aPRO的系数,X和X1都是控制变量,以上都是企业层面的数据
现在想要做2SLS,工具变量是PRO在城市层面的中间数(bysort city:egen PRO_med=median(PRO)),因为aPRO的关系所以不知道该如何写命令,求大神解惑,谢谢!(medaPRO是PRO_med和audit的乘积)
lear
input float(RPRO PRO audit aPRO size capital inventory lev roe sPRO cPRO iPRO lPRO roePRO yPRO ciPRO PRO_med medaPRO)
.03157064 .072472155 0 0 10.95107 .7090766 .05554679 .9791458 1 .7936476 .05138831 .0040255953 .070960805 .072472155 144.9443 94.28627 .2699338 0
.9023742 1.5155238 1 1.5155238 8.703341 .27760252 .05146937 .58492446 0 13.19012 .4207132 .07800305 .8864669 0 3037.1096 1971.6964 .2699338 .2699338
.11367114 .12288339 1 .12288339 11.958924 .16784354 .03883358 .19049326 0 1.469553 .02062518 .004772002 .023408456 0 246.50407 159.8713 .2699338 .2699338
.1334891 .4035148 1 .4035148 11.759575 .542716 .14787494 .28274715 0 4.7451625 .21899395 .05966973 .11409266 0 809.4507 524.9728 .2699338 .2699338
.05285412 .4368667 1 .4368667 10.912685 .6494678 .2187067 .9546548 0 4.7673883 .28373083 .09554567 .4170569 0 876.7914 568.3635 .2699338 .2699338
.2951807 .5974699 1 .5974699 9.024011 .6746988 .05421687 .4819277 0 5.391574 .4031122 .032392945 .28793728 0 1197.3296 777.3083 .2699338 .2699338
0 .04838645 0 0 10.131858 .3475389 .0930723 .9650631 1 .4902447 .016816175 .0045034387 .04669598 .04838645 96.8213 62.95078 .2699338 0
.1965571 .212946 1 .212946 11.193698 .261067 .09051754 .17195305 0 2.3836534 .05559318 .01927535 .036616717 0 427.3827 277.04276 .2699338 .2699338
-.14758717 -.032484166 0 0 11.706953 .12957427 .10258374 .6861292 1 -.3802906 -.004209112 -.0033323474 -.022288334 -.032484166 -65.0333 -42.2619 .2699338 0
.3415882 1.1997913 1 1.1997913 11.127866 .3511118 .16244617 .22324775 0 13.351117 .4212609 .1949015 .26785073 0 2407.9812 1560.9285 .2699338 .2699338
-.030972036 .06084821 0 0 11.736197 .4156588 .17145005 .6572919 1 .7141266 .025292095 .01043243 .03999503 .06084821 121.63557 79.16352 .2699338 0
.02439313 .06446418 1 .06446418 10.650767 .09743043 .08674955 .8102783 0 .686593 .006280773 .005592239 .05223393 0 129.18622 83.8679 .2699338 .2699338
-.04368911 -.018830005 1 -.018830005 11.984322 .28412277 .29524475 .9950881 1 -.22566484 -.005350033 -.00555946 -.018737514 -.018830005 -37.77299 -24.497837 .2699338 .2699338
.013907683 .07364807 0 0 11.980577 .2452263 .17724778 .530835 0 .8823464 .018060442 .013053957 .03909497 0 147.3698 95.81614 .2699338 0
.033412524 .034265973 0 0 13.040038 .12266822 .3278645 .7588938 1 .4468296 .004203346 .011234595 .026004236 .034265973 68.63474 44.58003 .2699338 0
1.8246685 5.982312 1 5.982312 10.595884 .8423818 .12509382 .465349 0 63.38788 5.039391 .7483502 2.783863 0 11988.553 7782.988 .2699338 .2699338
-.14418504 .39021215 1 .39021215 11.570892 .5055394 .17689303 .4154367 0 4.515103 .1972676 .06902581 .16210847 0 782.3754 507.666 .2699338 .2699338
.06302123 .5700936 0 0 11.165168 .18015774 .175726 .9200306 1 6.365191 .10270677 .10018026 .5245035 .5700936 1141.8975 741.6917 .2699338 0
-.02000511 .3320421 1 .3320421 12.164213 .38012835 .17198034 .5974995 1 4.0390306 .1262186 .05710471 .19839497 .3320421 666.0764 431.9867 .2699338 .2699338
.631671 1.2017573 1 1.2017573 11.547955 .8272969 0 .423309 0 13.87784 .9942101 0 .50871474 0 2410.725 1563.4862 .2699338 .2699338
-.16812545 -.1200766 0 0 9.302737 .7830963 .07211889 .6489788 0 -1.117041 -.09403153 -.00865979 -.07792716 0 -240.27325 -156.21965 .2699338 0
-.024554724 -.009115953 0 0 11.557344 .3370033 .02705133 1.0767443 1 -.1053562 -.0030721065 -.00024659862 -.00981555 -.009115953 -18.250137 -11.859855 .2699338 0
.00004830801 .08866935 0 0 10.63106 .56037295 .26909977 .7675177 0 .9426492 .04968791 .0238609 .068055294 0 177.3387 115.35883 .2699338 0
.05142857 .16266666 1 .16266666 11.338573 .4080476 .05964286 .6560833 0 1.8444078 .06637575 .009701905 .1067229 0 326.1467 211.62933 .2699338 .2699338
.43706295 2.516783 1 2.516783 7.958577 .55944055 .05944056 .4167832 0 20.03001 1.4079906 .149599 1.048953 0 5043.634 3274.335 .2699338 .2699338
.02152288 .0923072 1 .0923072 13.06446 .2007375 .242001 .8172081 1 1.2059437 .018529516 .022338433 .0754342 .0923072 185.16824 120.09167 .2699338 .2699338
.325 .4170802 1 .4170802 9.257224 .379771 .254771 .4484733 0 3.8610046 .15839495 .10625993 .1870493 0 835.8287 542.6213 .2699338 .2699338
.1742225 .17488353 1 .17488353 12.150047 .3827068 .05727038 .58846766 0 2.1248431 .06692912 .010015646 .1029133 0 350.4666 227.52347 .2699338 .2699338
.002609189 .006485158 0 0 10.87597 .21049348 .24414824 .9799206 0 .07053238 .0013650834 .00158334 .006354939 0 12.957345 8.43719 .2699338 0
.012084592 .04795033 0 0 12.285226 .26116762 .1540693 .6058233 0 .58908063 .012523074 .007387674 .02904943 0 95.90067 62.38338 .2699338 0
.1589053 .4967753 1 .4967753 12.044112 .4513007 .3634675 .17763603 0 5.983218 .2241951 .18056168 .0882452 0 996.0345 646.3047 .2699338 .2699338
.07447384 .27707878 0 0 11.01799 .4889683 .3163662 .7560571 0 3.052851 .13548274 .08765836 .2094874 0 554.71173 360.4795 .2699338 0
.05922593 .6171734 0 0 12.501287 .3440448 .18182394 .6609313 1 7.715462 .2123353 .1122169 .4079092 .6171734 1233.1124 802.9426 .2699338 0
.05937167 .09363247 0 0 10.88637 .6874988 .0980484 .6160021 0 1.0193177 .06437221 .009180512 .05767779 0 187.1713 121.81584 .2699338 0
-.017136628 .04363774 0 0 11.566514 .14706412 .3431875 .9818302 1 .50473654 .006417546 .01497593 .04284485 .04363774 87.36275 56.7727 .2699338 0
0 .2109744 0 0 11.89618 .5039297 .10932824 .818302 1 2.5097895 .10631627 .02306546 .1726408 .2109744 421.9488 274.47772 .2699338 0
-.21236643 .1906892 1 .1906892 15.005204 .3521496 .3196796 .7161124 1 2.86133 .06715112 .06095944 .1365549 .1906892 382.3318 248.08664 .2699338 .2699338
.7676595 1.996312 1 1.996312 8.860783 .51914895 .024113474 .027943263 0 17.688887 1.0363833 .04813802 .05578347 0 4000.6094 2597.202 .2699338 .2699338
.8639122 3.329121 1 3.329121 11.69766 .3760911 .10059024 .6025438 0 38.94293 1.252053 .3348771 2.0059416 0 6678.217 4331.187 .2699338 .2699338
.017941087 .6413981 1 .6413981 11.680777 .4441222 .26688424 .4800044 0 7.492028 .28485915 .17117904 .3078739 0 1287.286 834.4589 .2699338 .2699338
.010367054 .1767207 0 0 11.105814 .59532434 .07790315 .9848551 1 1.9626273 .10520614 .0137671 .1740443 .1767207 353.7949 229.91364 .2699338 0
.13578802 .154882 1 .154882 12.95069 .33336025 .10593716 .1687377 0 2.0058289 .05163151 .01640776 .026134433 0 310.53845 201.5015 .2699338 .2699338
.6590493 1.7032007 1 1.7032007 10.672368 .54464966 .009270633 .11356525 0 18.177185 .9276477 .015789747 .1934244 0 3416.6206 2215.864 .2699338 .2699338
.3470039 .4724534 1 .4724534 10.590843 .39913 .13809751 .8672333 0 5.00368 .1885703 .06524464 .4097273 0 946.7966 614.6619 .2699338 .2699338
.05395974 .18168965 0 0 12.450273 .14311452 .4535093 .6407645 0 2.2620857 .02600243 .08239795 .11642028 0 363.7427 236.37823 .2699338 0
.09899803 .3046463 1 .3046463 11.983454 .1958472 .1270458 .4351778 0 3.650715 .05966412 .03870403 .1325753 0 610.5112 396.34485 .2699338 .2699338
.93 1.44625 1 1.44625 8.476371 .3479167 .4166667 .20833333 0 12.25895 .5031745 .6026042 .3013021 0 2898.285 1881.571 .2699338 .2699338
.11679105 1.3838338 1 1.3838338 11.35771 .4752228 .1016082 .9058314 0 15.71718 .6576293 .14060888 1.25352 0 2773.203 1800.3677 .2699338 .2699338
-.016909577 -.006608165 0 0 11.090187 .1306982 .0395269 .9618161 1 -.07328579 -.0008636753 -.00026120027 -.00635584 -.006608165 -13.21633 -8.597222 .2699338 0
.0006796516 .08801488 0 0 10.931517 .3685858 .1979217 .6767541 1 .9621361 .032441035 .017420053 .05956443 .08801488 176.11777 114.50735 .2699338 0
end
扫码加我 拉你入群
请注明:姓名-公司-职位
以便审核进群资格,未注明则拒绝
全部回复
沙发
黃河泉
2020-2-1 17:07:54
请 ssc install xtivreg2 并 help xtivreg2。类似
复制代码
扫码加我 拉你入群
请注明:姓名-公司-职位
以便审核进群资格,未注明则拒绝
藤椅
rongyan123
2020-2-1 17:50:47
黃河泉 发表于 2020-2-1 17:07
请 ssc install xtivreg2 并 help xtivreg2。类似
谢谢黄老师,问题解决了!
扫码加我 拉你入群
请注明:姓名-公司-职位
以便审核进群资格,未注明则拒绝
栏目导航
Stata专版
行业分析报告
区域经济学
经管文库(原现金交易版)
武汉大学经济与管理学院
数据交流中心
热门文章
CDA数据分析师:以数据思维赋能企业管理,驱 ...
CDA全国考点信息一览(更新于2025年12月10日 ...
企业级AI平台发展趋势报告(2026)
【24重磅,顶刊热点!】2001-2024上市公司大数 ...
当AI遇见ML:高校教师如何借助AI与机器学习 ...
CDA 认证考试大纲 2025 重磅更新:一二级考 ...
CDA数据分析师实战:指标体系搭建的全流程方 ...
Essentials of Statistics for Research by ...
Navigating Qualitative Research: A Compr ...
2026年市场展望报告-机遇与挑战并存
推荐文章
12月武汉站|Deepseek辅助论文写作与数据分 ...
2026JG学术冬训营:从Stata初高到Python机器 ...
关于如何利用文献的若干建议
关于学术研究和论文发表的一些建议
关于科研中如何学习基础知识的一些建议 (一 ...
一个自编的经济学建模小案例 --写给授课本科 ...
AI智能体赋能教学改革: 全国AI教育教学应用 ...
2025中国AIoT产业全景图谱报告-406页
关于文献求助的一些建议
几种免费下载文献的方法----我的文献应助经
说点什么
分享
微信
QQ空间
QQ
微博
扫码加好友,拉您进群
各岗位、行业、专业交流群