楼主: 玄一无相
5117 4

[数据管理求助] 数据清理中destring用法疑惑 [推广有奖]

第一责任版主

已卖：5794份资源

学术权威

3%

还不是VIP/贵宾

-

0%
威望
4 级
论坛币
48219 个
通用积分
10259.3995
学术水平
277 点
热心指数
310 点
信用等级
228 点
经验
32341 点
帖子
2688
精华
4
在线时间
3665 小时
注册时间
2010-4-7
最后登录
2025-11-28
毕业学校
郑州大学 浙江财经学院

初级学术勋章 初级热心勋章 初级信用勋章

楼主
玄一无相 在职认证  学生认证  发表于 2018-4-17 11:02:34 |AI写论文

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币
在前面清理数据过程中，遇到原始数据中存在字符，如-，/，无等缺失信息，我用下面这个语句：
destring var1,replace ignore("-")
代替
replace var1="." if var1=="-"
gen var2=real(var1)
drop var1
rename var2 var1

但是有时候缺无法进行，我确认过“”内都是相同的，求教。
也欢迎其他更好的方法
二维码

扫码加我 拉你入群

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

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

分享0
关键词：destring string tring RING 数据清理

相关帖子

资源与环境经济学版
跨学科讨论区

沙发
黃河泉 在职认证  发表于 2018-4-17 16:58:17
1.        你若要问程序 (code)，请附上资料；你若要附上资料，请用 dataex 印出资料。
2.        尔后建议请用 dataex (先 ssc install dataex 并见说明) 将原始 Stata 资料中具有”代表性”的一部分资料列出，以供有意回答者实验之用，并能提供具体操作指令。并请参考 http://www.jianshu.com/p/9870080fe769,  https://bbs.pinggu.org/thread-5048204-1-1.html, 与 https://bbs.pinggu.org/thread-5917273-1-1.html。
已有 1 人评分经验 学术水平 热心指数 信用等级 收起 理由
玄一无相 + 100 + 2 + 2 + 2 热心帮助其他会员

总评分: 经验 + 100  学术水平 + 2  热心指数 + 2  信用等级 + 2   查看全部评分

藤椅
玄一无相 在职认证  学生认证  发表于 2018-4-17 18:41:22
黃河泉 发表于 2018-4-17 16:58
1.        你若要问程序 (code)，请附上资料；你若要附上资料，请用 dataex 印出资料。
2.        尔后建议请用 dataex ( ...
谢谢，下载了，下次提问用这个。
----------------------- copy starting from the next line -----------------------
  1. * Example generated by -dataex-. To install: ssc install dataex
  2. clear
  3. input str4(var1 var2 var3 var4)
  4. "7.66" "8.53" "3.8"  "0.33"
  5. "7.23" "6.42" "4.8"  "0.91"
  6. "6.62" "6.9"  "5.3"  "0.2"
  7. "7.23" "7.02" "3.9"  "0.57"
  8. "8"    "0.39" "3.1"  "0.04"
  9. "8.37" "7.51" "5.1"  "0.18"
  10. "7.5"  "8.87" "3.4"  "0.86"
  11. "8.23" "4.32" "5.3"  "0.7"
  12. "7.39" "9.37" "3.2"  "0.27"
  13. "7.33" "9.35" "5.3"  "0.08"
  14. "6.68" "10.8" "4.3"  "0.2"
  15. "7.53" "8.77" "20.8" "1.04"
  16. "8.16" "11.6" "4.9"  "1.06"
  17. "6.96" "5.29" "6.6"  "0.16"
  18. "—"  "—"  "—"  "—"
  19. "7.58" "14.1" "4.8"  "0.34"
  20. "7.39" "8.87" "2.4"  "0.01"
  21. "6.97" "10.2" "2.6"  "0.18"
  22. "7.76" "8.72" "6.8"  "0.97"
  23. "7.34" "10.1" "2"    "0.17"
  24. "8.18" "10.3" "4.3"  "0.22"
  25. "7.96" "9.3"  "2.5"  "0.21"
  26. "8.19" "7.33" "4.3"  "0.55"
  27. "7.78" "0.88" "8.3"  "4.95"
  28. "7.22" "9.15" "3.1"  "0.41"
  29. "7.52" "7.02" "5.7"  "0.62"
  30. "8"    "5.68" "2.3"  "0.35"
  31. "7.92" "6.77" "3.1"  "0.7"
  32. "8.01" "8.28" "2.6"  "0.8"
  33. "7.7"  "5.49" "4.2"  "0.47"
  34. "6.94" "5.13" "5.8"  "0.5"
  35. "7.59" "8.31" "2.5"  "0.3"
  36. "7.78" "5.8"  "5.1"  "1.74"
  37. "8.3"  "6.97" "5.2"  "1.43"
  38. "7.97" "7.16" "8.4"  "0.11"
  39. "8.18" "2.31" "8.7"  "2.17"
  40. "8.81" "7.37" "4.2"  "0.21"
  41. "7.51" "9.26" "3.9"  "0.14"
  42. "7.97" "3.34" "11.9" "1.05"
  43. "8.38" "5.61" "8.5"  "1.62"
  44. "9.11" "20.2" "3.9"  "0.05"
  45. "8.29" "10.3" "3.4"  "0.06"
  46. "7.67" "2.62" "7.9"  "2.82"
  47. "8.02" "6.53" "5.4"  "0.22"
  48. "8.09" "6.47" "3.8"  "0.39"
  49. "9.04" "8.7"  "6.2"  "0.31"
  50. "8.08" "7.8"  "6.9"  "0.25"
  51. "7.59" "8.8"  "4.3"  "0.2"
  52. "7.57" "7.79" "8.8"  "1.92"
  53. "8"    "8.74" "6.2"  "0.38"
  54. "8.65" "10.9" "4.1"  "0.8"
  55. "8.45" "8.33" "2.4"  "0.33"
  56. "7.44" "10.4" "1.3"  "0.32"
  57. "7.05" "9.68" "3.5"  "0.85"
  58. "8.04" "9.99" "4.2"  "0.74"
  59. "7.94" "7.68" "3.7"  "0.49"
  60. "8.11" "9.61" "3.1"  "0.46"
  61. "8.47" "6.93" "2.7"  "0.22"
  62. "6.96" "6.05" "2.8"  "2.14"
  63. "7.76" "3.96" "68.6" "8.97"
  64. "7.32" "8.13" "2.7"  "0.18"
  65. "7.91" "5.97" "4.2"  "1.58"
  66. "8.28" "8.49" "0.6"  "0.12"
  67. "8.07" "9.09" "1.9"  "0.18"
  68. "7.96" "9.22" "2.5"  "0.09"
  69. "8.81" "10.5" "2.6"  "0.17"
  70. "6.98" "8.49" "2.5"  "0.18"
  71. "7.65" "8.58" "2.8"  "0.25"
  72. "7.38" "8.94" "2.5"  "0.19"
  73. "7.93" "6.36" "0.9"  "0.21"
  74. "7.36" "4.68" "3.4"  "0.78"
  75. "7.36" "7.94" "1.7"  "0.12"
  76. "7.49" "6.41" "3"    "0.26"
  77. "7.9"  "7.99" "1.5"  "0.11"
  78. "6.93" "6.49" "1.6"  "0.51"
  79. "6.99" "5.8"  "2"    "0.48"
  80. "6.59" "6.38" "1.9"  "0.71"
  81. "7.81" "8.33" "2.3"  "0.17"
  82. "8.15" "9.69" "2"    "0.2"
  83. "6.52" "9.05" "2.2"  "0.14"
  84. "7.91" "6.73" "1.5"  "0.77"
  85. "7.54" "9.99" "2.5"  "0.15"
  86. "7.18" "2.3"  "1.7"  "1.98"
  87. "6.67" "7.6"  "1.4"  "0.1"
  88. "7.3"  "8.53" "1"    "0.22"
  89. "7.31" "6.12" "1.8"  "0.34"
  90. "7.71" "8.46" "0.6"  "0.19"
  91. "7.07" "9.99" "－"  "0.06"
  92. "7.08" "6.52" "3"    "0.09"
  93. "8.65" "9.58" "2.2"  "0.07"
  94. "7.81" "7.88" "4.2"  "0.53"
  95. "7.68" "7.77" "1.1"  "0.07"
  96. "7.59" "6.21" "3.6"  "0.31"
  97. "7.55" "6.97" "1"    "0.08"
  98. "7.26" "7.84" "3.2"  "0.26"
  99. "8.47" "7.06" "3.2"  "0.28"
  100. "8.39" "10.3" "3"    "0.11"
  101. "7.57" "9.42" "2.5"  "0.43"
  102. "7.14" "7.6"  "4.3"  "1.15"
  103. "7.07" "4.37" "8.3"  "1.64"
  104. "7.43" "2.17" "7.7"  "1.48"
  105. "7.47" "4.67" "3.2"  "0.38"
  106. "7.76" "6.44" "4.5"  "0.28"
  107. "7.58" "7.52" "6.2"  "0.23"
  108. "7.85" "3.61" "12.9" "0.7"
  109. "8.41" "8.06" "1.5"  "0.29"
  110. "7.14" "9.65" "2"    "0.17"
  111. "7"    "6.57" "2.1"  "0.11"
  112. "8.12" "9.76" "1.9"  "0.08"
  113. "8.41" "7.72" "0.6"  "0.08"
  114. "8.39" "10.4" "2.2"  "0.07"
  115. "7.5"  "9.99" "1.7"  "0.15"
  116. "7.53" "8.62" "2.4"  "0.09"
  117. "7.69" "6.73" "1.9"  "0.04"
  118. "7.81" "11.4" "2.1"  "0.09"
  119. "7.15" "7.48" "6.8"  "0.11"
  120. "7.18" "11.8" "4.3"  "1.17"
  121. "7.64" "7.58" "3.6"  "0.76"
  122. "7.36" "11.6" "4.7"  "1.08"
  123. "7.17" "10.8" "7.4"  "0.15"
  124. "7.49" "13.3" "4.8"  "0"   
  125. "7.01" "9.27" "11"   "0.32"
  126. "8.15" "9.06" "9.3"  "3.18"
  127. "7.74" "1.42" "53.1" "0.44"
  128. "7.45" "2.02" "7.7"  "1.4"
  129. "7.22" "7.09" "1.8"  "0.01"
  130. "7.24" "6.93" "2"    "0"   
  131. "7.24" "10.6" "2.5"  "0.44"
  132. "—"  "—"  "—"  "—"
  133. "8.68" "7.29" "4.4"  "0.46"
  134. "8.89" "10.2" "4.9"  "0.19"
  135. end
复制代码

------------------ copy up to and including the previous line ------------------

Listed 131 out of 131 observations


command and result：
. destring var1 var2 var3 var4,replace ignore("-")
var1: contains characters not specified in ignore(); no replace
var2: contains characters not specified in ignore(); no replace
var3: contains characters not specified in ignore(); no replace
var4: contains characters not specified in ignore(); no replace

资源与环境经济学版
跨学科讨论区

板凳
黃河泉 在职认证  发表于 2018-4-17 18:49:18
玄一无相 发表于 2018-4-17 18:41
谢谢，下载了，下次提问用这个。
----------------------- copy starting from the next line --------- ...
试试
  1. destring var1 var2 var3 var4, replace force
复制代码
报纸
玄一无相 在职认证  学生认证  发表于 2018-4-17 19:49:36
黃河泉 发表于 2018-4-17 18:49
试试
谢谢，结果跟我用原始方法得到的结果一致：每个变量缺失值一致
返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注jltj
拉您入交流群

京ICP备16021002号-2 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问：王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2026-1-8 14:02