求问如何生成多个变量限定条件的计数变量

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

数据如下
如何生成一个变量，计算出相同level 相同code，同时edu 和major不是缺失值的数量。
万分感谢。

* Example generated by -dataex-. To install: ssc install dataex
clear
input  double level str8 code double(edu major)
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" 2 0
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" 3 0
1 "0709" . .
1 "0709" 2 0
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" 2 1
1 "0709" . .
1 "0709" . .
1 "0709" 2 0
1 "0709" 2 0
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
2 "0709" . .
2 "0709" . .
2 "0709" . .
2 "0709" 2 0
2 "0709" . .
2 "0709" . .
2 "0709" . .
3 "0709" . .
3 "0709" . .
3 "0709" 1 1
3 "0709" . .
3 "0709" 1 2
3 "0709" . .
3 "0709" . .
3 "0709" . .
1 "0709" 2 0
1 "0809" 3 0
1 "0809" 3 0
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
2 "0809" 2 0
2 "0809" . .
1 "0709" 2 0
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
1 "0709" . .
end

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：多个变量 generated generate install example

试试

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input  double level str8 code double(edu major)
   
4. 1 "0709" . .
   
5. 1 "0709" . .
   
6. 1 "0709" . .
   
7. 1 "0709" 2 0
   
8. 1 "0709" . .
   
9. 1 "0709" . .
   
10. 1 "0709" . .
    
11. 1 "0709" . .
    
12. 1 "0709" . .
    
13. 1 "0709" . .
    
14. 1 "0709" . .
    
15. 1 "0709" . .
    
16. 1 "0709" . .
    
17. 1 "0709" . .
    
18. 1 "0709" . .
    
19. 1 "0709" . .
    
20. 1 "0709" . .
    
21. 1 "0709" . .
    
22. 1 "0709" . .
    
23. 1 "0709" . .
    
24. 1 "0709" . .
    
25. 1 "0709" . .
    
26. 1 "0709" . .
    
27. 1 "0709" . .
    
28. 1 "0709" 3 0
    
29. 1 "0709" . .
    
30. 1 "0709" 2 0
    
31. 1 "0709" . .
    
32. 1 "0709" . .
    
33. 1 "0709" . .
    
34. 1 "0709" . .
    
35. 1 "0709" . .
    
36. 1 "0709" . .
    
37. 1 "0709" . .
    
38. 1 "0709" . .
    
39. 1 "0709" . .
    
40. 1 "0709" . .
    
41. 1 "0709" . .
    
42. 1 "0709" . .
    
43. 1 "0709" . .
    
44. 1 "0709" . .
    
45. 1 "0709" . .
    
46. 1 "0709" . .
    
47. 1 "0709" . .
    
48. 1 "0709" . .
    
49. 1 "0709" . .
    
50. 1 "0709" . .
    
51. 1 "0709" . .
    
52. 1 "0709" . .
    
53. 1 "0709" . .
    
54. 1 "0709" . .
    
55. 1 "0709" . .
    
56. 1 "0709" . .
    
57. 1 "0709" . .
    
58. 1 "0709" . .
    
59. 1 "0709" . .
    
60. 1 "0709" 2 1
    
61. 1 "0709" . .
    
62. 1 "0709" . .
    
63. 1 "0709" 2 0
    
64. 1 "0709" 2 0
    
65. 1 "0709" . .
    
66. 1 "0709" . .
    
67. 1 "0709" . .
    
68. 1 "0709" . .
    
69. 1 "0709" . .
    
70. 1 "0709" . .
    
71. 1 "0709" . .
    
72. 2 "0709" . .
    
73. 2 "0709" . .
    
74. 2 "0709" . .
    
75. 2 "0709" 2 0
    
76. 2 "0709" . .
    
77. 2 "0709" . .
    
78. 2 "0709" . .
    
79. 3 "0709" . .
    
80. 3 "0709" . .
    
81. 3 "0709" 1 1
    
82. 3 "0709" . .
    
83. 3 "0709" 1 2
    
84. 3 "0709" . .
    
85. 3 "0709" . .
    
86. 3 "0709" . .
    
87. 1 "0709" 2 0
    
88. 1 "0809" 3 0
    
89. 1 "0809" 3 0
    
90. 1 "0709" . .
    
91. 1 "0709" . .
    
92. 1 "0709" . .
    
93. 1 "0709" . .
    
94. 2 "0809" 2 0
    
95. 2 "0809" . .
    
96. 1 "0709" 2 0
    
97. 1 "0709" . .
    
98. 1 "0709" . .
    
99. 1 "0709" . .
    
100. 1 "0709" . .
     
101. 1 "0709" . .
     
102. 1 "0709" . .
     
103. 1 "0709" . .
     
104. end
     
105. 
     
106. missings tag edu major, gen(temp)
     
107. bys level code: egen wanted = total(temp == 0)

复制代码

黃河泉 发表于 2020-5-19 07:31
试试

谢谢黄老师，真的可以了。

黃河泉 发表于 2020-5-19 07:31
试试

老师，我接下再生成 同样的计数变量，相同level 相同industry 同时edu 和major不是缺失值的数量。
使用如下命令好像有问题，请老师帮忙看看命令对吗
missings tag edu major, gen(temp)
bys level industry : egen n_industry = total(temp == 0)
* Example generated by -dataex-. To install: ssc install dataex
clear
input double level str8 code byte industry double(edu major)
1 "0807"  . . .
1 "0809"  . . .
1 "0807"  . . .
1 "0807"  . . .
1 "0809"  . . .
1 "0826"  . . .
1 "0828"  . . .
1 "0809"  . . .
1 "0825"  9 2 0
1 "0825" 14 . .
1 "0814"  . . .
1 "0807"  9 2 0
1 "0807"  7 . .
1 "0814"  9 . .
1 "0825"  . . .
1 "0804"  . . .
1 "0807"  . . .
2 "0828"  . . .
2 "0804"  3 . .
2 "0809"  . . .
1 "0809"  . . .
1 "0828"  . . .
1 "0809" 18 . .
2 "0807"  . . .
1 "0809"  . 2 1
1 "0809"  9 . .
1 "0828"  . . .
1 "0825"  . . .
1 "0807"  . . .
1 "0804"  . . .
1 "0828" 19 . .
1 "0807"  . . .
1 "0828"  . . .
1 "0807"  . . .
3 "0809"  9 . .
1 "0809"  6 . .
1 "0807"  . . .
1 "0809"  9 2 1
1 "0807"  . . .
1 "0809" 10 2 1
1 "0807"  . . .
2 "0809"  3 2 1
1 "0830"  . . .
1 "0809"  . . .
1 "0825"  . . .
1 "0828"  5 . .
1 "0809"  9 2 1
1 "0825"  . . .
1 "0807"  3 2 0
1 "0826"  . . .
1 "0814"  . . .
1 "0809"  . . .
1 "0807"  4 . .
1 "0809"  . . .
1 "0804"  . . .
1 "0809"  9 . .
1 "0809"  9 2 1
1 "0807"  . . .
1 "0814"  . . .
1 "0828"  . . .
1 "0809"  9 2 1
1 "0804"  . . .
1 "0807"  . . .
1 "0804" 19 2 0
1 "0809"  9 2 1
1 "0807"  . . .
1 "0807"  . . .
1 "0804"  3 2 0
1 "0825"  . . .
1 "0807"  . . .
1 "0825"  . . .
1 "0809"  . . .
1 "0809"  . . .
1 "0828"  . . .
1 "0807"  9 . .
2 "0809"  9 2 1
2 "0825"  . . .
1 "0825"  . . .
1 "0809"  . . .
1 "0809"  . . .
1 "0825"  . . .
1 "0825"  . . .
1 "0807"  . . .
1 "0825" 14 . .
1 "0807"  . . .
1 "0809"  . . .
1 "0809"  . . .
1 "0814"  . . .
1 "0809"  . . .
1 "0809"  . . .
1 "0809"  . . .
1 "0809"  . . .
3 "0809"  3 . .
1 "0828"  . . .
1 "0825" 19 . .
1 "0807"  . . .
1 "0807"  . . .
3 "0809"  3 2 1
1 "0826"  . . .
1 "0814"  . . .
end

楼上的问题已经解决了，原因是没有考虑到industry的缺失值