I would like to add values in between two numbers to generate a series of consecutive numbers.
1) Have data:
id | year | month | time |
1 | 2002 | 1 | 200201 |
1 | 2002 | 3 | 200203 |
2 | 2001 | 12 | 200112 |
2 | 2002 | 4 | 200204 |
2) Want data
id | year | month |
1 | 2002 | 1 |
1 | 2002 | 2 |
1 | 2002 | 3 |
2 | 2001 | 12 |
2 | 2002 | 1 |
2 | 2002 | 2 |
2 | 2002 | 3 |
2 | 2002 | 4 |
I ran the code:
tssest id time
tsfill, full
Then, there is error saying that: op. sys. refuses to provide memory. I believe my code is incorrect.
Anyone can help?
I appreciate.
Been
0 Response to adding values between two numbers for a consecutive series
Post a Comment