reshape解决不了

DΘstinyじò 发表于 2022-1-23 19:56
尝试建议还是先整理 学历类型这个变量，把同一意思的不同表述统一标准。

OK，我先搞定这个，不过我认为问题不出在这里，假如整理好了，比如学历分为ABCD四类，然后第1家公司有ABC，第二家有D，第三家有BCD，还是不整齐……

qianchen 发表于 2022-1-23 19:14
clear
input str6 code int 类别代码 str72 学历 int 次类别代码 long 人数 double 比例
"000001" 5000  ...

values of variable 学历 not unique within code

bbsflyingsnow 发表于 2022-1-23 20:18
values of variable 学历 not unique within code

我的完全没有问题

qianchen 发表于 2022-1-23 19:14
clear
input str6 code int 类别代码 str72 学历 int 次类别代码 long 人数 double 比例
"000001" 5000  ...

values of variable 学历 not unique within code
    Your data are currently long.  You are performing a reshape wide.  You specified
    i(code) and j(学历).  There are observations within i(code) with the same value of
    j(学历).  In the long data, variables i() and j() together must uniquely identify the
    observations.

qianchen 发表于 2022-1-23 20:22
我的完全没有问题

ok 谢谢您，看来是后面有重复的数据 我马上查查

你肯定又用了其他数据了 用贴出来的数据试试 完全没有任何问题

qianchen 发表于 2022-1-23 19:14
clear
input str6 code int 类别代码 str72 学历 int 次类别代码 long 人数 double 比例
"000001" 5000  ...

搞定了 非常感谢！

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 code str132 学历 str4 year double 数量
   
4. "000001" "其他" "2018" 34626
   
5. "000001" "其他" "2019" 34253
   
6. "000001" "其他" "2020" 38097
   
7. "000002" "其他" "2013" 35330
   
8. "000004" "其他" "2012"   277
   
9. "000004" "其他" "2013"   243
   
10. "000004" "其他" "2014"   220
    
11. "000004" "其他" "2015"   208
    
12. "000004" "其他" "2016"   179
    
13. "000004" "其他" "2017"   172
    
14. "000004" "其他" "2018"   210
    
15. "000004" "其他" "2019"   251
    
16. "000004" "其他" "2020"   264
    
17. "000004" "合计" "2015"   208
    
18. "000004" "合计" "2016"   179
    
19. "000004" "合计" "2017"   172
    
20. "000004" "合计" "2018"   210
    
21. "000004" "合计" "2019"   251
    
22. "000004" "合计" "2020"   264
    
23. "000005" "其他" "2012"   382
    
24. "000005" "其他" "2013"   376
    
25. "000005" "其他" "2014"   421
    
26. "000005" "其他" "2015"   535
    
27. "000005" "其他" "2016"   618
    
28. "000005" "其他" "2017"   705
    
29. "000005" "其他" "2018"   745
    
30. "000005" "其他" "2019"   680
    
31. "000005" "其他" "2020"   629
    
32. "000005" "合计" "2015"   535
    
33. "000005" "合计" "2016"   618
    
34. "000005" "合计" "2017"   705
    
35. "000005" "合计" "2018"   745
    
36. "000005" "合计" "2019"   680
    
37. "000005" "合计" "2020"   629
    
38. "000006" "其他" "2012"   290
    
39. "000006" "其他" "2013"   296
    
40. "000006" "其他" "2014"   329
    
41. "000006" "其他" "2015"   352
    
42. "000006" "其他" "2016"   370
    
43. "000006" "其他" "2017"   370
    
44. "000006" "其他" "2018"   377
    
45. "000006" "其他" "2019"   385
    
46. "000006" "其他" "2020"   397
    
47. "000006" "合计" "2013"   296
    
48. "000006" "合计" "2014"   329
    
49. "000006" "合计" "2015"   352
    
50. "000006" "合计" "2016"   370
    
51. "000006" "合计" "2017"   370
    
52. "000006" "合计" "2018"   377
    
53. "000006" "合计" "2019"   385
    
54. "000006" "合计" "2020"   397
    
55. "000007" "其他" "2012"   762
    
56. "000007" "其他" "2013"   674
    
57. "000007" "其他" "2014"   614
    
58. "000007" "其他" "2015"   121
    
59. "000007" "其他" "2016"   155
    
60. "000007" "其他" "2017"   102
    
61. "000007" "其他" "2018"    84
    
62. "000007" "其他" "2019"    84
    
63. "000007" "其他" "2020"    76
    
64. "000007" "合计" "2015"   121
    
65. "000007" "合计" "2016"   155
    
66. "000007" "合计" "2017"   102
    
67. "000007" "合计" "2018"    84
    
68. "000007" "合计" "2019"    84
    
69. "000007" "合计" "2020"    76
    
70. "000008" "其他" "2012"  1685
    
71. "000008" "其他" "2013"  1622
    
72. "000008" "其他" "2014"  1278
    
73. "000008" "其他" "2015"  2617
    
74. "000008" "其他" "2016"  1903
    
75. "000008" "其他" "2017"  2417
    
76. "000008" "其他" "2018"  2631
    
77. "000008" "其他" "2019"  2618
    
78. "000008" "其他" "2020"  2394
    
79. "000008" "合计" "2013"  1622
    
80. "000008" "合计" "2014"  1278
    
81. "000008" "合计" "2015"  2617
    
82. "000008" "合计" "2016"  1903
    
83. "000008" "合计" "2017"  2417
    
84. "000008" "合计" "2018"  2631
    
85. "000008" "合计" "2019"  2618
    
86. "000008" "合计" "2020"  2394
    
87. "000009" "其他" "2012"  8524
    
88. "000009" "其他" "2013" 11953
    
89. "000009" "其他" "2014" 11915
    
90. "000009" "其他" "2015"  8202
    
91. "000009" "其他" "2016"  8887
    
92. "000009" "其他" "2017" 10944
    
93. "000009" "其他" "2018" 13620
    
94. "000009" "其他" "2019" 13179
    
95. "000009" "其他" "2020" 13345
    
96. "000009" "合计" "2015"  8202
    
97. "000009" "合计" "2016"  8887
    
98. "000009" "合计" "2017" 10944
    
99. "000009" "合计" "2018" 13620
    
100. "000009" "合计" "2019" 13239
     
101. "000009" "合计" "2020" 13345
     
102. "000010" "其他" "2012"   420
     
103. "000010" "其他" "2013"   596
     
104. end

复制代码

加上年了，怎么把年的分开啊
如果不控制年度，就又重复了

qianchen 发表于 2022-1-23 20:47
你肯定又用了其他数据了 用贴出来的数据试试 完全没有任何问题

如果加个新的年度变量怎么办啊，

reshape wide 数量,i(code year) j(学历) string 谢谢各位