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