I have a data set with the following format:
id date price
1 1 400
2 1 500
2 2 450
2 3 450
3 2 600
3 3 .
Where I have multiple id's observed at different dates, and not necessarily the same date. What I would like, is to delete all but the most recent date and fill in the price with the most recent price observed.
For example:
id date price
1 1 400
2 3 450
3 3 600
Any clues on how to do this? I've played around with dup and duplicated but still haven't found anything.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
