请问如何把第m个观测的X变量值赋给第n个观测的Y变量

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

各位好，第一次发帖求助，规矩什么不太懂……
数据节选如下，在所有日期中有一期的价格数据（标签为当前）是0，我希望能够编写一个程序自动在遇到这种情况的时候把上一期的价格赋到这一期上，请问各位能提供点意见嘛？


. dataex
copy starting from the next line ------ ----------------

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int 日期 double 当前 str6(环比 同比)
   
4. 19539 143.96 "-.0084" ".0088"
   
5. 19532 143.55 "-.0106" ".0074"
   
6. 19525 143.86 "-.0087" ".0089"
   
7. 19518 144.51 "-.0019" ".0123"
   
8. 19511 145.18 ".0017"  ".0179"
   
9. 19504 145.09 ".0006"  ".0158"
   
10. 19497 145.12 "-.0038" ".015"  
    
11. 19490 144.79 "-.0068" ".0162"
    
12. 19483 144.93 "-.0074" ".0164"
    
13. 19476 145.01 "-.0049" ".0231"
    
14. 19469 145.68 "-.0034" ".0299"
    
15. 19462 145.78 "-.0011" ".031"  
    
16. 19455 146.01 "-.001"  ".0355"
    
17. 19448  145.2 "-.0066" ".0288"
    
18. 19441 145.73 "-.0009" ".0411"
    
19. 19434 146.17 "暂无" ".0468"
    
20. 19427 145.94 "暂无" ".0515"
    
21. 19420 146.16 "-.0029" ".0526"
    
22. 19413 145.86 "-.0006" ".0512"
    
23. 19392 146.58 ".0131"  ".0611"
    
24. 19385 145.95 ".021"   "暂无"
    
25. 19378 146.09 ".0205"  ".0613"
    
26. 19371 145.91 ".0215"  ".0622"
    
27. 19364 144.68 ".0125"  ".0534"
    
28. 19357 144.43 ".0107"  ".0522"
    
29. 19350 142.95 ".0034"  ".0405"
    
30. 19343 143.15 ".0039"  ".0437"
    
31. 19336 142.84 ".0006"  ".041"  
    
32. 19329  142.9 ".0021"  ".0441"
    
33. 19322 142.46 "-.002"  ".0407"
    
34. 19315 142.59 "-.0013" ".0419"
    
35. 19308 142.75 "-.0052" ".0441"
    
36. 19301  142.6 "暂无" ".0451"
    
37. 19294 142.75 "-.0209" ".0424"
    
38. 19287 142.77 "-.0198" ".0373"
    
39. 19280  143.5 "-.0177" ".0251"
    
40. 19273      0 "-1"     "-1"   
    
41. 19266 145.37 ".0008"  ".0385"
    
42. 19259  145.8 ".0073"  ".0461"
    
43. 19252 145.66 ".0068"  ".0487"
    
44. 19245 146.09 ".0159"  ".0564"
    
45. 19238 145.26 ".0111"  ".0549"
    
46. 19231 144.74 ".0066"  ".055"  
    
47. 19224 144.67 ".0105"  ".0531"
    
48. 19217  143.8 ".0035"  ".0529"
    
49. 19210 143.67 ".0027"  ".0538"
    
50. 19203 143.79 ".0091"  ".06"   
    
51. 19196 143.17 ".0041"  ".0555"
    
52. 19189  143.3 ".0038"  ".0574"
    
53. 19182 143.28 ".0046"  ".0635"
    
54. 19175 142.71 ".0006"  ".0593"
    
55. 19168 142.49 "-.0024" ".0607"
    
56. 19161 142.59 "-.0027" ".0621"
    
57. 19154 142.76 ".002"   ".0634"
    
58. 19147 142.63 ".0003"  ".0638"
    
59. 19140 142.83 ".0078"  ".0661"
    
60. 19133 142.97 ".0107"  ".071"  
    
61. 19126 142.48 ".0076"  ".0691"
    
62. 19119 142.59 ".0112"  ".0724"
    
63. 19112 141.73 ".0125"  ".0746"
    
64. 19105 141.45 ".013"   ".0753"
    
65. 19098  141.4 ".0188"  ".0724"
    
66. 19091 141.01 ".0156"  ".0687"
    
67. 19084 141.13 ".0164"  ".0697"
    
68. 19077 139.98 ".0088"  ".0668"
    
69. 19070 139.64 ".0082"  ".0638"
    
70. 19063 138.79 ".0028"  ".0665"
    
71. 19056 138.85 ".0051"  ".0776"
    
72. 19049 138.76 "暂无" ".0822"
    
73. 19042  138.5 ".0062"  ".0865"
    
74. 19035  138.4 ".0075"  ".0861"
    
75. 19028 138.14 ".0058"  "暂无"
    
76. 19021      0 "-1"     "-1"   
    
77. 19014 137.65 ".0036"  ".0886"
    
78. 19007 137.37 ".0012"  ".0907"
    
79. 19000 137.35 ".0036"  ".0979"
    
80. 18993 137.26 ".0029"  ".0972"
    
81. 18986 137.39 ".0037"  ".1058"
    
82. 18979 137.15 ".0021"  ".1048"
    
83. 18972 137.21 ".0036"  ".0944"
    
84. end
    
85. format %tdnn/dd/CCYY 日期

复制代码

copy up to and including the previous line - ----------------
Listed 80 out of 80 observations

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：变量值 observations observation including generated

试试

1. sort 日期
   
2. replace 当前 = 当前[_n-1] if 当前 == 0

复制代码

黃河泉 发表于 2019-5-15 10:51
试试

非常感谢！