Thanks Martin,
I was thinking I would get referred to -egen- with the concatenate
function. I'll try this option to see how I can use it.
Cheers
Kiron
On Sat, Nov 22, 2008 at 2:19 PM, Martin Weiss <[email protected]> wrote:
> Remember when you -generate- you add a whole column to your dataset which
> may or may not be what you want. Sometimes it is preferable to just
> -generate newvar=.- and then add values by -replace newvar=5 in 1- and so
> on. Apart from this general advice, you are not looking for a "function" but
> for the -if- qualifier, as far as I can tell from your description of your
> problem. See -h if-
>
> HTH
> Martin
> _______________________
> ----- Original Message ----- From: "Kir1" <[email protected]>
> To: <[email protected]>
> Sent: Saturday, November 22, 2008 11:12 PM
> Subject: st: Reshape related
>
>
>> Hi All,
>>
>> Perhaps the subject line is not the best one to address my problem,
>> but here it is:
>>
>> My original data set is of the 'long' format like this
>>
>> gvkey year revenue
>> 1000 1999 111
>> 1000 2000 222
>> .
>> .
>> 1001 1999 888
>>
>>> From this I want to retrieve only one value of revenue per 'gvkey'
>>
>> which corresponds to a year value that i lookup in a different
>> database. So if in the other data base my gvkey is 1000 and lookupyear
>> is 2000, then only 222 should be in the revenue cell of the final
>> database.
>>
>> 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/
>>
>
>
> *
> * 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/
>
*
* 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/