请问如何删除唯一行数据，计算出增长率

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

我做个一个出口贸易分析，需要计算各个国家2000年-2019年的出口变化。但是很多国家缺失2000年或者2019年的数据，无法做到2019年-2000年，因此要删除缺失部分的值。请问大家有什么好的方法能删除这些数据吗。

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int(year period) str6 tradeflow int reportercode str10 reporter str18 partner double netweightkg
   
4. 2019 2019 "Export"  76 "Brazil"     "Italy"               2725056115
   
5. 2000 2000 "Export"  76 "Brazil"     "Italy"              10532028834
   
6. 2019 2019 "Export" 398 "Kazakhstan" "Russian Federation"  8477781000
   
7. 2019 2019 "Export" 604 "Peru"       "China"              15485909500
   
8. 2000 2000 "Export" 604 "Peru"       "China"               1461954752
   
9. 2019 2019 "Export"  76 "Brazil"     "Malaysia"           28521944000
   
10. 2000 2000 "Export"  76 "Brazil"     "Malaysia"             893905167
    
11. end

复制代码

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：增长率 generated Malaysia reporter generate

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int(year period) str6 tradeflow int reportercode str10 reporter str18 partner double netweightkg
   
4. 2019 2019 "Export"  76 "Brazil"     "Italy"               2725056115
   
5. 2000 2000 "Export"  76 "Brazil"     "Italy"              10532028834
   
6. 2019 2019 "Export" 398 "Kazakhstan" "Russian Federation"  8477781000
   
7. 2019 2019 "Export" 604 "Peru"       "China"              15485909500
   
8. 2000 2000 "Export" 604 "Peru"       "China"               1461954752
   
9. 2019 2019 "Export"  76 "Brazil"     "Malaysia"           28521944000
   
10. 2000 2000 "Export"  76 "Brazil"     "Malaysia"             893905167
    
11. end

复制代码

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int(year period) str6 tradeflow int reportercode str10 reporter str18 partner double netweightkg
   
4. 2019 2019 "Export"  76 "Brazil"     "Italy"               2725056115
   
5. 2000 2000 "Export"  76 "Brazil"     "Italy"              10532028834
   
6. 2019 2019 "Export" 398 "Kazakhstan" "Russian Federation"  8477781000
   
7. 2019 2019 "Export" 604 "Peru"       "China"              15485909500
   
8. 2000 2000 "Export" 604 "Peru"       "China"               1461954752
   
9. 2019 2019 "Export"  76 "Brazil"     "Malaysia"           28521944000
   
10. 2000 2000 "Export"  76 "Brazil"     "Malaysia"             893905167
    
11. end

复制代码

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int(year period) str6 tradeflow int reportercode str10 reporter str18 partner double netweightkg
   
4. 2019 2019 "Export"  76 "Brazil"     "Italy"               2725056115
   
5. 2000 2000 "Export"  76 "Brazil"     "Italy"              10532028834
   
6. 2019 2019 "Export" 398 "Kazakhstan" "Russian Federation"  8477781000
   
7. 2019 2019 "Export" 604 "Peru"       "China"              15485909500
   
8. 2000 2000 "Export" 604 "Peru"       "China"               1461954752
   
9. 2019 2019 "Export"  76 "Brazil"     "Malaysia"           28521944000
   
10. 2000 2000 "Export"  76 "Brazil"     "Malaysia"             893905167
    
11. end

复制代码

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int(year period) str6 tradeflow int reportercode str10 reporter str18 partner double netweightkg
   
4. 2019 2019 "Export"  76 "Brazil"     "Italy"               2725056115
   
5. 2000 2000 "Export"  76 "Brazil"     "Italy"              10532028834
   
6. 2019 2019 "Export" 398 "Kazakhstan" "Russian Federation"  8477781000
   
7. 2019 2019 "Export" 604 "Peru"       "China"              15485909500
   
8. 2000 2000 "Export" 604 "Peru"       "China"               1461954752
   
9. 2019 2019 "Export"  76 "Brazil"     "Malaysia"           28521944000
   
10. 2000 2000 "Export"  76 "Brazil"     "Malaysia"             893905167
    
11. end

复制代码