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 at the end of May, 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   Nick Cox <n.j.cox@durham.ac.uk>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   RE: st: RE: merging observations in one dataset
Date   Tue, 31 Aug 2010 20:47:28 +0100

I don't want to seem to keep picking on you, but you don't seem to have studied the FAQ on how to post answers. You sent a spreadsheet attachment which by accident will have got through to some readers but will appear pure garbage to most, as witness

<http://www.hsph.harvard.edu/cgi-bin/lwgate/STATALIST/archives/statalist.1008/date/article-1600.html> 

Attachments are deprecated on this list. 

Now to the main point: 

Your spreadsheet example showed 

Bank ID	Quarter  	Assets	Capital	Holding company
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
				
			
After				
Bank ID	Quarter  	Assets	Capital	Holding company
1	1	4960968	7687536	x
1	2	896589	8474562	x
1	3	5359579	796454	x
2	1	643363	67867	y
2	2	465346	68678	y
2	3	54363	76868	y

Please explain how you get from "before" or "after". I can't see the connection. What happened to Bank #3? 

And _no_ attachments please. 

Nick 
n.j.cox@durham.ac.uk 

David Kehrl

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.

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/


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