请问老师们怎么编写下面的代码，按行业分组求中位数并生成虚拟变量

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 company_id int year double 任期年数 str3 行业代码 byte 任期01
"000002" 21184    16.8849315068493 "K70" .
"000004" 21184   4.646575342465753 "C27" .
"000005" 21184  10.542465753424658 "N77" .
"000006" 21184   .7945205479452054 "K70" .
"000007" 21184  2.0383561643835617 "K70" .
"000008" 21184  1.6821917808219178 "C37" .
"000009" 21184  13.517808219178082 "S90" .
"000011" 21184   9.468493150684932 "K70" .
"000012" 21184    .852054794520548 "C30" .
"000014" 21184    4.33972602739726 "K70" .
"000016" 21184    .810958904109589 "C39" .
"000017" 21184   7.353424657534247 "C37" .
"000019" 21184   6.506849315068493 "F51" .
"000020" 21184  10.463013698630137 "C39" .
"000021" 21184   7.638356164383562 "C39" .
"000022" 21184   .5726027397260274 "G55" .
"000023" 21184   5.117808219178082 "C30" .
"000025" 21184  2.7534246575342465 "F51" .
"000026" 21184   .8164383561643835 "F52" .
"000027" 21184  .38082191780821917 "D44" .
"000028" 21184  1.8136986301369864 "F51" .
"000029" 21184   8.202739726027398 "K70" .
"000030" 21184  1.5013698630136987 "C36" .
"000031" 21184   .6575342465753424 "K70" .
"000032" 21184  1.4821917808219178 "F51" .
"000035" 21184  3.5397260273972604 "N77" .
"000036" 21184   1.621917808219178 "K70" .
"000037" 21184  .38904109589041097 "D44" .
"000038" 21184   .4657534246575342 "L72" .
"000039" 21184  13.802739726027397 "C33" .
"000040" 21184   1.126027397260274 "D44" .
"000042" 21184   .4931506849315068 "K70" .
"000043" 21184                  .4 "K70" .
"000045" 21184   .4520547945205479 "C39" .
"000046" 21184  2.5945205479452054 "K70" .
"000049" 21184   3.495890410958904 "C38" .
"000050" 21184   4.843835616438356 "C39" .
"000055" 21184   15.69041095890411 "C33" .
"000056" 21184   7.304109589041096 "L72" .
"000058" 21184   7.619178082191781 "L72" .
"000059" 21184   2.271232876712329 "C25" .
"000060" 21184  2.5424657534246577 "C32" .
"000061" 21184    4.63013698630137 "L72" .
"000062" 21184   3.419178082191781 "F51" .
"000063" 21184  1.7397260273972603 "C39" .
"000065" 21184  3.6027397260273974 "E48" .
"000066" 21184  1.0986301369863014 "C39" .
"000068" 21184   4.734246575342466 "C39" .
"000069" 21184  2.3095890410958906 "K70" .
"000070" 21184 .010958904109589041 "C38" .
"000078" 21184  14.819178082191781 "F52" .
"000088" 21184   .7835616438356164 "G54" .
"000089" 21184   7.054794520547945 "G56" .
"000090" 21184   5.578082191780822 "E48" .
"000096" 21184  10.032876712328767 "F51" .
"000099" 21184   .8876712328767123 "G56" .
"000100" 21184   9.536986301369863 "C39" .
"000150" 21184  1.7315068493150685 "Q83" .
"000151" 21184   4.646575342465753 "F51" .
"000153" 21184  1.7616438356164383 "C27" .
"000155" 21184   1.178082191780822 "C26" .
"000157" 21184  11.476712328767123 "C35" .
"000158" 21184   .4958904109589041 "I65" .
"000159" 21184  .01643835616438356 "F51" .
"000301" 21184   3.808219178082192 "C28" .
"000333" 21184   4.213698630136986 "C38" .
"000338" 21184  15.046575342465754 "C36" .
"000400" 21184   1.663013698630137 "C38" .
"000401" 21184  12.657534246575343 "C30" .
"000402" 21184    .947945205479452 "K70" .
"000403" 21184   2.254794520547945 "C27" .
"000404" 21184   8.972602739726028 "C34" .
"000408" 21184  1.3753424657534246 "C26" .
"000411" 21184  12.361643835616439 "F51" .
"000413" 21184  1.4273972602739726 "C39" .
"000417" 21184   .7917808219178082 "F52" .
"000419" 21184   8.057534246575342 "F52" .
"000420" 21184  1.1479452054794521 "C28" .
"000421" 21184   1.252054794520548 "D45" .
"000423" 21184  11.693150684931506 "C27" .
"000425" 21184    .726027397260274 "C35" .
"000426" 21184   6.046575342465753 "B09" .
"000429" 21184   2.202739726027397 "G54" .
"000430" 21184   8.561643835616438 "N78" .
"000488" 21184  .12602739726027398 "C22" .
"000498" 21184   2.893150684931507 "E48" .
"000501" 21184   .5095890410958904 "F52" .
"000503" 21184   16.49041095890411 "I64" .
"000505" 21184  1.3013698630136987 "C13" .
"000506" 21184   4.342465753424658 "B09" .
"000507" 21184   2.884931506849315 "G55" .
"000509" 21184   .6767123287671233 "C29" .
"000510" 21184  2.2958904109589042 "C26" .
"000511" 21184 .005479452054794521 "C30" .
"000513" 21184   3.813698630136986 "C27" .
"000514" 21184  1.7972602739726027 "K70" .
"000516" 21184   2.632876712328767 "Q83" .
"000517" 21184  3.5232876712328767 "K70" .
"000518" 21184  10.884931506849314 "C27" .
"000519" 21184   4.134246575342465 "C35" .
end

具体想做的是：根据第三列求出的年数，求出行业中位数（其中制造业C用二级代码，其他行业用一级代码），大于行业中位数在第五列取1，小于行业中位数取0，可以用stata写这个过程的代码吗？求懂的老师解答~

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏2 回帖

关键词：虚拟变量 中位数 generated generate install

试试

1. bys 行业代码: egen med = median(任期年数)
   
2. gen wanted = (任期年数 > med)

复制代码

黃河泉 发表于 2019-9-3 07:24
试试

谢谢老师！！可以实现的！