> It is not quite clear what you want. Your data seem to be sorted by
> id and bid rather than id and time. Should they be ranked according
> to the level of bid within each id?
The rank column was just for better understanding - but it failed :-)
> | id bid time rank maxbid |
> |---------------------------------|
>
1. | 1 1 1 1 17 |
2. | 1 4 2 2 17 |
3. | 1 3 3 3 17 |
4. | 1 8 4 4 17 |
5. | 1 10 5 5 17 |
|---------------------------------|
6. | 1 12 6 6 17 |
7. | 1 17 7 7 17 |
8. | 1 14 8 8 17 |
9. | 2 5 1 1 9 |
10. | 2 6 2 2 9 |
11. | 2 9 3 3 9 |
this is how far I am now with the egen command. but I want a list like that:
| id bid time rank maxbid |
1. | 1 1 1 1 1 |
2. | 1 4 2 2 4 |
3. | 1 3 3 3 4 |
4. | 1 8 4 4 8 |
5. | 1 10 5 5 10 |
6. | 1 12 6 6 12 |
7. | 1 17 7 7 17 |
8. | 1 14 8 8 17 |
With foucus on maxbid: not the total max of the entire list, but the max from
bid[1] to bid[_n] for all _n's.
Robert
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
