Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[no subject]



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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index