我做了一个时间序列分析,EXECL数据如下:
| id | rate | year | month |
| 1 | 87.30 | 2020 | 1 |
| 1 | 87.16 | 2020 | 2 |
| 1 | 87.32 | 2020 | 3 |
| 1 | 87.29 | 2020 | 4 |
| 1 | 87.83 | 2020 | 5 |
| 1 | 87.41 | 2020 | 6 |
| 1 | 87.93 | 2020 | 7 |
| 1 | 87.31 | 2020 | 8 |
| 1 | 88.83 | 2020 | 9 |
| 1 | 88.93 | 2020 | 10 |
| 1 | 96.69 | 2020 | 11 |
| 1 | 98.01 | 2020 | 12 |
| 1 | 97.97 | 2021 | 1 |
| 1 | 97.99 | 2021 | 2 |
| 1 | 98.40 | 2021 | 3 |
| 1 | 99.10 | 2021 | 4 |
操作如下:
. generate monthly=ym(year,month)
. format monthly %tm
. tsset id monthly
panel variable: id (strongly balanced)
time variable: monthly, 2020m1 to 2021m4
delta: 1 month
. itsa rate, trperiod(`=tm(2020m10)') lag(2) replace figure
panel variable: id (strongly balanced)
time variable: monthly, 2020m1 to 2021m4
delta: 1 month
结果:

求助:红线框中的想显示成-x2020m10 和-x-t2020m10这种格式。改怎么操作,求大神们帮忙,万分感谢!