条件识别问题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

Example generated by -dataex-. To install: ssc install dataex
clear
input int(year city) str1(OrganTC InstiN)
1979 1407 "A" "1"
1980 2109 "A" "1"
1981 1408 "S" "1"
1983 3212 "U" "1"
1983 4290 "A" "1"
1984 2306 "A" "1"
1984 3212 "A" "1"
1984 3212 "A" "1"
1984 3212 "A" "1"
1984 3212 "A" "1"
1984 3212 "A" "1"
1984 3212 "A" "1"
1984 3212 "S" "1"
1984 3212 "S" "1"
1984 3212 "S" "1"
1984 3212 "U" "1"
1984 4408 "A" "1"
1984 4408 "A" "1"
1985 1409 "A" "1"
1985 1507 "A" "1"

我想实现通过命令bysort year city :egen PostbankA=sum( InstiN ) if OrganTC =="A"，实现各年各地区同类型机构的数量，但无论我把OrganTC用 字符型的还是转化成数值型的都显示type mismatch   r(109);该如何解决这个问题

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：如何解决 数值型 同类型 字符型 如何解

1. *Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int(year city) str1(OrganTC InstiN)
   
4. 1979 1407 "A" "1"
   
5. 1980 2109 "A" "1"
   
6. 1981 1408 "S" "1"
   
7. 1983 3212 "U" "1"
   
8. 1983 4290 "A" "1"
   
9. 1984 2306 "A" "1"
   
10. 1984 3212 "A" "1"
    
11. 1984 3212 "A" "1"
    
12. 1984 3212 "A" "1"
    
13. 1984 3212 "A" "1"
    
14. 1984 3212 "A" "1"
    
15. 1984 3212 "A" "1"
    
16. 1984 3212 "S" "1"
    
17. 1984 3212 "S" "1"
    
18. 1984 3212 "S" "1"
    
19. 1984 3212 "U" "1"
    
20. 1984 4408 "A" "1"
    
21. 1984 4408 "A" "1"
    
22. 1985 1409 "A" "1"
    
23. 1985 1507 "A" "1"
    
24. end
    
25. 
    
26. destring   InstiN ,replace
    
27. 
    
28. bysort year city         :egen PostbankA=sum( InstiN ) if OrganTC =="A"
    
29. bysort year city OrganTC :egen Postbank=sum( InstiN )
    
30. list
    
31. collapse (sum) Postbank=InstiN, by(year city OrganTC)

复制代码