从年料到季资料。

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

丞续 https://bbs.pinggu.org/thread-6901045-1-1.html (季资料到月资料)，现在考虑"从年料到季资料"。Justin Blasongame 之例子：

1. * Example generated by -dataex-. To install: ssc install dataex

复制代码

扫码加我 拉你入群

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

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

关键词：generated generate install example thread

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input float quarter double actual
   
4. 120 5.53167750606359
   
5. 121 5.55368383532152
   
6. 122 5.99257380339251
   
7. 123 6.51753884341743
   
8. 124 7.11796664922873
   
9. 125 7.92801679615688
   
10. 126 8.25485569136677
    
11. 127 8.67277199478431
    
12. 128 9.20021634242936
    
13. 129 9.76269957404261
    
14. 130 10.1830358427499
    
15. 131 10.4102265690718
    
16. 132 10.2773943455484
    
17. 133 10.0154104224425
    
18. 134  9.5826549660854
    
19. 135 9.95134031636706
    
20. 136 9.92773625845649
    
21. 137 9.63138769049475
    
22. 138 9.07682910607205
    
23. 139 8.34761641490052
    
24. 140 7.75129340482802
    
25. 141 7.89493979154778
    
26. 142 8.14962626311586
    
27. 143 8.33093225230938
    
28. 144 8.57404456396557
    
29. 145 8.44885890148089
    
30. 146 7.79678877918148
    
31. 147 7.71998395583676
    
32. 148 7.45451087356006
    
33. 149 7.04061798144419
    
34. 150 6.61707431893162
    
35. 151 6.35037393095157
    
36. 152 6.46695367494215
    
37. 153 6.54562174148723
    
38. 154 6.68989927208012
    
39. 155 6.60924489412037
    
40. 156 6.09804630208552
    
41. 157 5.71371244886627
    
42. 158 5.82743908009751
    
43. 159 5.80563485822728
    
44. 160  5.6316545874983
    
45. 161 5.48587561694067
    
46. 162 5.38917048043787
    
47. 163 4.97819839097589
    
48. 164 5.09156128290642
    
49. 165 5.27502122307945
    
50. 166 5.82461741515249
    
51. 167 6.49075279183011
    
52. 168 6.82047507469195
    
53. 169  6.9398943545054
    
54. 170 6.63033184074372
    
55. 171 6.58606844140168
    
56. 172 6.71885363257488
    
57. 173 7.04650720031624
    
58. 174 7.18072187921208
    
59. 175 6.92469384555496
    
60. 176 6.69736580496448
    
61. 177 6.71537464060312
    
62. 178  6.3579525796945
    
63. 179 6.20077360275311
    
64. 180 5.81731610526503
    
65. 181  5.4142186104994
    
66. 182  4.9986633230299
    
67. 183 5.21578197654047
    
68. 184 4.96909409801882
    
69. 185 4.79155918565776
    
70. 186 4.83431872227202
    
71. 187 4.52904243433792
    
72. 188 4.82484607810868
    
73. 189  4.8777152421154
    
74. 190 5.21288258118221
    
75. 191 5.56200941208299
    
76. 192 6.09049348703451
    
77. 193 6.91519447863969
    
78. 194 8.06853215439807
    
79. 195 9.29101875437506
    
80. 196 10.7127515613771
    
81. 197 11.6192127748699
    
82. 198 11.8210484043695
    
83. 199 12.2518055958176
    
84. 200 12.2944696787286
    
85. 201  12.453210991768
    
86. 202 12.5037121144232
    
87. 203 12.7543352430669
    
88. 204 12.1853108422148
    
89. 205 12.3096776322852
    
90. 206 12.2548626587353
    
91. 207 11.9575092117242
    
92. 208 11.4614064148757
    
93. 209 11.0811333397946
    
94. 210 10.6843475043398
    
95. 211 10.4211826768583
    
96. 212  10.229906345801
    
97. 213 10.0389107712647
    
98. 214 9.54772493555333
    
99. 215 9.21486683031624
    
100. 216  8.7801908492634
     
101. 217 8.37615558109597
     
102. 218 8.10181568422713
     
103. 219 7.77056111482696
     
104. 220  7.3882813708474
     
105. 221 7.02454387602501
     
106. 222 6.25570998143439
     
107. 223 5.87671255195986
     
108. 224 5.46389088847185
     
109. 225 5.24194110284552
     
110. 226  5.2213800543667
     
111. 227 5.03340233411886
     
112. 228 4.93221669344379
     
113. 229 4.73377452398139
     
114. 230 4.66991176428847
     
115. 231 4.42388556255185
     
116. end
     
117. format %tq!Qq-YY quarter
     
118. 
     
119. tempfile temp
     
120. save `temp'
     
121. 
     
122. * Example generated by -dataex-. To install: ssc install dataex
     
123. clear
     
124. input int year float value
     
125. 1990  5.9
     
126. 1991    8
     
127. 1992  9.9
     
128. 1993  9.9
     
129. 1994  9.3
     
130. 1995    8
     
131. 1996  8.1
     
132. 1997  6.9
     
133. 1998  6.6
     
134. 1999  5.9
     
135. 2000  5.4
     
136. 2001  5.7
     
137. 2002  6.7
     
138. 2003    7
     
139. 2004  6.5
     
140. 2005  5.4
     
141. 2006  4.8
     
142. 2007  5.1
     
143. 2008  7.6
     
144. 2009 11.6
     
145. 2010 12.5
     
146. 2011 12.2
     
147. 2012 10.9
     
148. 2013  9.8
     
149. 2014  8.3
     
150. 2015  6.6
     
151. 2016  5.3
     
152. 2017  4.7
     
153. end
     
154. 
     
155. gen quarter =  .
     
156. 
     
157. levelsof (year), local(years)
     
158. foreach v in `years' {
     
159.     replace quarter = tq(`v'-2) if year == `v' & quarter == .
     
160. }
     
161. format quarter %tq!Qq-YY
     
162. qui ssc install insob
     
163. insob 3 _N, after
     
164. replace quarter = quarter[_n-1] + 1 if quarter == .
     
165. 
     
166. tsset quarter, quarterly
     
167. tsfill
     
168. mipolate value quarter, gen(unrate) pchip
     
169. 
     
170. merge 1:1 quarter using `temp'
     
171. keep if _merge == 3
     
172. drop _merge
     
173. 
     
174. twoway line unrate actual quarter, scheme(s1color) legend(region(lcolor(white))) xtitle("")

复制代码

谢谢黄老师