STATA怎么按行业计算公司数量

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

如题，STATA怎么按行业计算公司数量？
如下表，现在我想要计算不同ind1中不同stkcd的数量，作为一个新变量num。具体说就是，比如行业11中000002和000006和000007，就是num=3，这个num不受年份acc的影响，也就是对于ind1=11来说，产生了一个新变量num=3。

谢谢大神指教！


----------------------- copy starting from the next line -----------------------

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 stkcd int acc byte ind1
   
4. "000002" 14975 11
   
5. "000002" 15340 11
   
6. "000002" 15705 11
   
7. "000002" 16070 11
   
8. "000002" 16436 11
   
9. "000002" 16801 11
   
10. "000002" 17166 11
    
11. "000002" 17531 11
    
12. "000002" 17897 11
    
13. "000002" 18262 11
    
14. "000002" 18627 11
    
15. "000002" 18992 11
    
16. "000002" 19358 11
    
17. "000002" 19723 11
    
18. "000002" 20088 11
    
19. "000002" 20453 11
    
20. "000002" 20819 11
    
21. "000003" 14975 19
    
22. "000003" 15340 19
    
23. "000004" 14975  3
    
24. "000004" 15340  3
    
25. "000004" 15705  3
    
26. "000004" 16070  3
    
27. "000004" 16436  3
    
28. "000004" 16801  3
    
29. "000004" 17166  3
    
30. "000004" 17531  3
    
31. "000004" 17897  3
    
32. "000004" 18262  3
    
33. "000004" 18627  3
    
34. "000004" 18992  3
    
35. "000004" 19358  3
    
36. "000004" 19723  3
    
37. "000004" 20088  3
    
38. "000004" 20453  3
    
39. "000004" 20819  3
    
40. "000005" 14975 14
    
41. "000005" 15340 14
    
42. "000005" 15705 14
    
43. "000005" 16070 14
    
44. "000005" 16436 14
    
45. "000005" 16801 14
    
46. "000005" 17166 14
    
47. "000005" 17531 14
    
48. "000005" 17897 14
    
49. "000005" 18262 14
    
50. "000005" 18627 14
    
51. "000005" 18992 14
    
52. "000005" 19358 14
    
53. "000005" 19723 14
    
54. "000005" 20088 14
    
55. "000005" 20453 14
    
56. "000005" 20819 14
    
57. "000006" 14975 11
    
58. "000006" 15340 11
    
59. "000006" 15705 11
    
60. "000006" 16070 11
    
61. "000006" 16436 11
    
62. "000006" 16801 11
    
63. "000006" 17166 11
    
64. "000006" 17531 11
    
65. "000006" 17897 11
    
66. "000006" 18262 11
    
67. "000006" 18627 11
    
68. "000006" 18992 11
    
69. "000006" 19358 11
    
70. "000006" 19723 11
    
71. "000006" 20088 11
    
72. "000006" 20453 11
    
73. "000006" 20819 11
    
74. "000007" 14975 11
    
75. "000007" 15340 11
    
76. "000007" 15705 11
    
77. "000007" 16070 11
    
78. "000007" 16436 11
    
79. "000007" 16801 11
    
80. "000007" 17166 11
    
81. "000007" 17531 11
    
82. "000007" 17897 11
    
83. "000007" 18262 11
    
84. "000007" 18627 11
    
85. "000007" 18992 11
    
86. "000007" 19358 11
    
87. "000007" 19723 11
    
88. "000007" 20088 11
    
89. "000007" 20453 11
    
90. "000007" 20819 11
    
91. "000008" 14975  3
    
92. "000008" 15340  3
    
93. "000008" 15705  3
    
94. "000008" 16070  3
    
95. "000008" 16436  3
    
96. "000008" 16801  3
    
97. "000008" 17166  3
    
98. "000008" 17531  3
    
99. "000008" 17897  3
    
100. "000008" 18262  3
     
101. "000008" 18627  3
     
102. "000008" 18992  3
     
103. "000008" 19358  3
     
104. end
     
105. format %tdnn/dd/CCYY acc

复制代码

------------------ copy up to and including the previous line ------------------

扫码加我 拉你入群

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

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

分享0 收藏10 回帖

关键词：Stata 公司数量 tata including generated

请先安装 ssc install egenmore 并试试

1. bys ind1: egen num = nvals(stkcd)

复制代码

黃河泉 发表于 2018-5-10 16:51
请先安装 ssc install egenmore 并试试

好像不行。我的意思是，比如ind1=11有stkcd 000002和000006和000007，那就是num=3，如果是ind1=3，有stkcd 000004和000008，那么num=2，以此类推

* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 stkcd int acc byte ind1
"000002" 14975 11
"000002" 15340 11
"000002" 15705 11
"000002" 16070 11
"000002" 16436 11
"000002" 16801 11
"000002" 17166 11
"000002" 17531 11
"000002" 17897 11
"000002" 18262 11
"000002" 18627 11
"000002" 18992 11
"000002" 19358 11
"000002" 19723 11
"000002" 20088 11
"000002" 20453 11
"000002" 20819 11
"000003" 14975 19
"000003" 15340 19
"000004" 14975  3
"000004" 15340  3
"000004" 15705  3
"000004" 16070  3
"000004" 16436  3
"000004" 16801  3
"000004" 17166  3
"000004" 17531  3
"000004" 17897  3
"000004" 18262  3
"000004" 18627  3
"000004" 18992  3
"000004" 19358  3
"000004" 19723  3
"000004" 20088  3
"000004" 20453  3
"000004" 20819  3
"000005" 14975 14
"000005" 15340 14
"000005" 15705 14
"000005" 16070 14
"000005" 16436 14
"000005" 16801 14
"000005" 17166 14
"000005" 17531 14
"000005" 17897 14
"000005" 18262 14
"000005" 18627 14
"000005" 18992 14
"000005" 19358 14
"000005" 19723 14
"000005" 20088 14
"000005" 20453 14
"000005" 20819 14
"000006" 14975 11
"000006" 15340 11
"000006" 15705 11
"000006" 16070 11
"000006" 16436 11
"000006" 16801 11
"000006" 17166 11
"000006" 17531 11
"000006" 17897 11
"000006" 18262 11
"000006" 18627 11
"000006" 18992 11
"000006" 19358 11
"000006" 19723 11
"000006" 20088 11
"000006" 20453 11
"000006" 20819 11
"000007" 14975 11
"000007" 15340 11
"000007" 15705 11
"000007" 16070 11
"000007" 16436 11
"000007" 16801 11
"000007" 17166 11
"000007" 17531 11
"000007" 17897 11
"000007" 18262 11
"000007" 18627 11
"000007" 18992 11
"000007" 19358 11
"000007" 19723 11
"000007" 20088 11
"000007" 20453 11
"000007" 20819 11
"000008" 14975  3
"000008" 15340  3
"000008" 15705  3
"000008" 16070  3
"000008" 16436  3
"000008" 16801  3
"000008" 17166  3
"000008" 17531  3
"000008" 17897  3
"000008" 18262  3
"000008" 18627  3
"000008" 18992  3
"000008" 19358  3
end
format %tdnn/dd/CCYY acc
save "doc1.dta",replace

use "doc1.dta",clear
duplicates drop stkcd,force
bys ind1: gen num = _N
duplicates drop ind1,force
keep ind1 num
save "ind.dta",replace

use "doc1.dta",clear
merge m:1 ind1 using ind.dta,nogen
save "doc2.dta",replace
erase doc1.dta
erase ind.dta

lancelot22 发表于 2018-5-10 17:19
好像不行。我的意思是，比如ind1=11有stkcd 000002和000006和000007，那就是num=3，如果是ind1=3，有stkc ...

奇怪，我的作法就是你要的答案啊？哪里错了？楼上做的答案与我的完全一样！

黃河泉 发表于 2018-5-10 17:57
奇怪，我的作法就是你要的答案啊？哪里错了？楼上做的答案与我的完全一样！

啊！是的！非常抱歉，是我太愚蠢了！！真的非常抱歉！！！您的做法是对的，而且很简单！点赞！！！

求学小灵通 发表于 2018-5-10 17:43
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 stkcd int acc byt ...

嗯嗯，谢谢您帮我解决问题！！非常感谢！！！

黃河泉 发表于 2018-5-10 16:51
请先安装 ssc install egenmore 并试试

黄老师的方案真的是：一击中的，简捷高效！
非常感谢！

黃河泉 发表于 2018-5-10 16:51
请先安装 ssc install egenmore 并试试

想请问黄老师 nvals这个是什么意思啊？

CatherineQueen 发表于 2021-3-10 11:29
想请问黄老师 nvals这个是什么意思啊？

这种问题应该先看看说明，请 help egenmore 之 nvals。