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]

From |
Austin Nichols <austinnichols@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: RE: merging observations in one dataset |

Date |
Tue, 31 Aug 2010 15:46:36 -0400 |

David Kehrl <davidkehrl@googlemail.com>: Read the FAQ before you post; attachments are not allowed. Give your examples in Stata-ese: clear all input id quarter assets capital str1 co 1 1 324532 8768 "x" 1 2 433243 787686 "x" 1 3 34234 7686 "x" 2 1 643363 67867 "y" 2 2 465346 68678 "y" 2 3 54363 76868 "y" 3 1 4636436 7678768 "x" 3 2 463346 7686876 "x" 3 3 5325345 788768 "x" end egen long ca=sum(assets), by(co quarter) bys co quarter: g long ck=sum(capital) by co quarter: replace ck=ck[_N] l, noo sepby(co) collapse (sum) assets capital, by(co quarter) l, noo sepby(co) On Tue, Aug 31, 2010 at 3:36 PM, David Kehrl <davidkehrl@googlemail.com> wrote: > 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/

**References**:**st: merging observations in one dataset***From:*David Kehrl <davidkehrl@googlemail.com>

**st: RE: merging observations in one dataset***From:*Nick Cox <n.j.cox@durham.ac.uk>

**Re: st: RE: merging observations in one dataset***From:*David Kehrl <davidkehrl@googlemail.com>

**Re: st: RE: merging observations in one dataset***From:*David Kehrl <davidkehrl@googlemail.com>

- Prev by Date:
**RE: st: RE: merging observations in one dataset** - Next by Date:
**Re: st: Re: Fortran** - Previous by thread:
**RE: st: RE: merging observations in one dataset** - Next by thread:
**Re: st: RE: merging observations in one dataset** - Index(es):