* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 code str132 学历 str4 year double 数量
"000001" "其他" "2018" 34626
"000001" "其他" "2019" 34253
"000001" "其他" "2020" 38097
"000002" "其他" "2013" 35330
"000004" "其他" "2012" 277
"000004" "其他" "2013" 243
"000004" "其他" "2014" 220
"000004" "其他" "2015" 208
"000004" "其他" "2016" 179
"000004" "其他" "2017" 172
"000004" "其他" "2018" 210
"000004" "其他" "2019" 251
"000004" "其他" "2020" 264
"000004" "合计" "2015" 208
"000004" "合计" "2016" 179
"000004" "合计" "2017" 172
"000004" "合计" "2018" 210
"000004" "合计" "2019" 251
"000004" "合计" "2020" 264
"000005" "其他" "2012" 382
"000005" "其他" "2013" 376
"000005" "其他" "2014" 421
"000005" "其他" "2015" 535
"000005" "其他" "2016" 618
"000005" "其他" "2017" 705
"000005" "其他" "2018" 745
"000005" "其他" "2019" 680
"000005" "其他" "2020" 629
"000005" "合计" "2015" 535
"000005" "合计" "2016" 618
"000005" "合计" "2017" 705
"000005" "合计" "2018" 745
"000005" "合计" "2019" 680
"000005" "合计" "2020" 629
"000006" "其他" "2012" 290
"000006" "其他" "2013" 296
"000006" "其他" "2014" 329
"000006" "其他" "2015" 352
"000006" "其他" "2016" 370
"000006" "其他" "2017" 370
"000006" "其他" "2018" 377
"000006" "其他" "2019" 385
"000006" "其他" "2020" 397
"000006" "合计" "2013" 296
"000006" "合计" "2014" 329
"000006" "合计" "2015" 352
"000006" "合计" "2016" 370
"000006" "合计" "2017" 370
"000006" "合计" "2018" 377
"000006" "合计" "2019" 385
"000006" "合计" "2020" 397
"000007" "其他" "2012" 762
"000007" "其他" "2013" 674
"000007" "其他" "2014" 614
"000007" "其他" "2015" 121
"000007" "其他" "2016" 155
"000007" "其他" "2017" 102
"000007" "其他" "2018" 84
"000007" "其他" "2019" 84
"000007" "其他" "2020" 76
"000007" "合计" "2015" 121
"000007" "合计" "2016" 155
"000007" "合计" "2017" 102
"000007" "合计" "2018" 84
"000007" "合计" "2019" 84
"000007" "合计" "2020" 76
"000008" "其他" "2012" 1685
"000008" "其他" "2013" 1622
"000008" "其他" "2014" 1278
"000008" "其他" "2015" 2617
"000008" "其他" "2016" 1903
"000008" "其他" "2017" 2417
"000008" "其他" "2018" 2631
"000008" "其他" "2019" 2618
"000008" "其他" "2020" 2394
"000008" "合计" "2013" 1622
"000008" "合计" "2014" 1278
"000008" "合计" "2015" 2617
"000008" "合计" "2016" 1903
"000008" "合计" "2017" 2417
"000008" "合计" "2018" 2631
"000008" "合计" "2019" 2618
"000008" "合计" "2020" 2394
"000009" "其他" "2012" 8524
"000009" "其他" "2013" 11953
"000009" "其他" "2014" 11915
"000009" "其他" "2015" 8202
"000009" "其他" "2016" 8887
"000009" "其他" "2017" 10944
"000009" "其他" "2018" 13620
"000009" "其他" "2019" 13179
"000009" "其他" "2020" 13345
"000009" "合计" "2015" 8202
"000009" "合计" "2016" 8887
"000009" "合计" "2017" 10944
"000009" "合计" "2018" 13620
"000009" "合计" "2019" 13239
"000009" "合计" "2020" 13345
"000010" "其他" "2012" 420
"000010" "其他" "2013" 596
end
我想调整成
代码 年份 其他 合计
000001 2012 12 10
000001 2013 18 90
000002
这种 ,怎么调整啊
reshape 了 但是不行 没法同时设置代码和年份两个条件