Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


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

Re: st: RE: merging observations in one dataset


From   David Kehrl <davidkehrl@googlemail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: merging observations in one dataset
Date   Tue, 31 Aug 2010 21:36:52 +0200

sorry again here is the before and after example


2010/8/31 David Kehrl <davidkehrl@googlemail.com>:
> sorry,here an example,
> what i want now is to sum all balance sheet variables (in this case
> assets and capital) at the holding company level.Hope this is more
> clear.
>
>
>
> Bank ID   Assets Securities Quarter  Holding
>
> 2010/8/31 Nick Cox <n.j.cox@durham.ac.uk>:
>> Merge, aggregate, sum: You are sending conflicting signals. I suggest a worked example showing exactly what you want, before and after. It can be hypothetical; all that is needful is that it be clear.
>>
>> Nick
>> n.j.cox@durham.ac.uk
>>
>> David Kehrl
>>
>> I am working with a panel data set containing quarterly data on
>> balance sheet items for all american banks. I am trying to aggregate
>> the bank level data for banks with common ownership . I have a string
>> variable indicating the highest holding company level. my question is
>> how is it possible to sum those banks with common ownership.
>>
>> *
>> *   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/
>>
>

Attachment: example2.ods
Description: application/vnd.oasis.opendocument.spreadsheet



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