用stata获得一个家庭里面收入第二高的那个人的职业

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

city                   province hhcode id      a1        a04 age a09   a14 zhiye
Guangzhou Guangdong 1002 100203 成员3 Male 12 Never Marr In school 23
Guangzhou Guangdong 1002 100204 成员4 Male 10 Never Marr In school 23
Guangzhou Guangdong 1002 100201 户主1 Male 38 Married Employed ( 23
Guangzhou Guangdong 1002 100202 成员2 0 38 Married Employed ( 23
Guangzhou Guangdong 1004 100401 户主1 Male 25 Never Marr Employed ( 5
Guangzhou Guangdong 1005 100501 户主1 0 17 Never Marr Employed ( 5
Guangzhou Guangdong 1006 100601 户主1 Male 42 Married Employed ( 5
Guangzhou Guangdong 1007 100701 户主1 Male 23 Never Marr Employed ( 5
Guangzhou Guangdong 1008 100801 户主1 0 20 Never Marr Employed ( 8
Guangzhou Guangdong 1009 100903 成员3 0 3 Never Marr In school 7
Guangzhou Guangdong 1009 100902 成员2 Male 28 Married Employed ( 7
Guangzhou Guangdong 1009 100901 户主1 0 24 Married Employed ( 7
Guangzhou Guangdong 1010 101001 户主1 0 36 Married Employed ( 8


比如这个的数据
多谢各位！！！

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：Stata tata employed province Married 职业

先把最大的选出后删掉，然后在重复一次

ssc d rowsort
是另一个选择

还可以考虑
egen rank_lo = rank(mpg) , by(rep78) unique

gsort hhcode - income
by hhcode : gen income_2nd = zhiyi if _n==2

wfldragon 发表于 2014-3-27 21:58
先把最大的选出后删掉，然后在重复一次

嘿嘿 酱紫也行 不过太累了

jjjj6666 发表于 2014-3-27 23:44
gsort hhcode - income
by hhcode : gen income_2nd = zhiyi if _n==2

多谢~~~~~~~好棒