怎么把百分数转化为小数

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input long stkcd int year str24 RDpr str33 RDeapoinr
   
4. 4 2016 "14.10%" "3.21%"
   
5. 4 2017 "13.77%" "3.72%"
   
6. 4 2018 "27.8%"  "4.76%"
   
7. 4 2019 "10.76%" "0.94%"
   
8. 4 2020 "55.68%" "11.69%"
   
9. 5 2015 ""       ""      
   
10. 5 2016 ""       ""      
    
11. 5 2017 "8.23%"  "2.84%"
    
12. 5 2018 "8.19%"  "3.32%"
    
13. 5 2019 "9.56%"  "4.04%"
    
14. 5 2020 "10.33%" "5.97%"
    
15. 7 2016 "13.55%" "16.23%"
    
16. 8 2015 "15.25%" "7.24%"
    
17. 8 2016 "38.52%" "7.29%"
    
18. 8 2017 "56.97%" "8.82%"
    
19. 8 2018 "56.63%" "9.47%"
    
20. 8 2019 "55.27%" "8.39%"
    
21. end

复制代码

怎么把百分数转化为数值型的小数

扫码加我 拉你入群

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

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

分享0 收藏1 回帖

关键词：百分数 generated generate install example

1. gen RDpr_1=substr(RDpr,1,(index(RDpr,"%")-1))
   
2. gen RDeapoinr_1=substr(RDeapoinr,1,(index(RDeapoinr,"%")-1))
   
3. destring RDpr_1 RDeapoinr_1,replace force
   
4. replace RDpr_1=RDpr_1/100
   
5. replace RDeapoinr_1=RDeapoinr_1/100

复制代码

谢谢大神