I can think of numerous inelegant ways to do this using Excel. But the
most elegant solution would be (i think) something like this.
step 1: reshape to wide: so the data now looks like this
gvkey revenue1999 revenue2000.....
1000 111 222
1001 888
step 2: gen singlerev = the value contained in the cell whose name is
("revenue" +"lookupyear")
The problem I have is finding the function that does this:" the value
contained in the cell whose name is ("revenue" +"lookupyear") )
Any help is appreciated. Any simpler way to do this is even more appreciated.
Thanks
Kiron
*
* 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/
