I'm stuck with something that I think you may help me : )
I have a data set on a monthly basis like this one below:
Identifier | Month | Share outstanding |
A | 1 | . |
A | 2 | . |
A | 3 | 10000 |
A | 4 | . |
I need to fill missing values of other months (in the specific quarter) with the maximum value of quarter
For instance, in the example above, in month 1 and 2 "share oustanding" should be 10000 (the maximum of that quarter).
Do you have any siggestions?
I tried many ways but I faced lots of problems.
The easiest way should be a carrybackward, nevertheless stata seems to not have this command.
Many thanks in advance
0 Response to Maximum value for each quarter
Post a Comment