Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Merge data for two panels in a panel data set
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: Merge data for two panels in a panel data set
Date
Mon, 26 Mar 2012 17:03:43 +0100
_all includes -collapseind date-. Sounds as if you want a wildcard
such as -item*-.
Nick
On Mon, Mar 26, 2012 at 4:59 PM, [email protected]
<[email protected]> wrote:
> thanks for helping me on that. I have adjusted your code but I struggle now with running one of the code lines:
>
> collapse (sum) item1, by(collapseind date)
>
> Since I have many variables (about 60), I would like to make the summation for all of them at once. I have tried with the following command following your suggestion:
>
> collapse (sum) _all, by(collapseind date)
>
> but I get the following message by Stata:
>
> "collapseind may not be both target and by()"
>
> I wonder if it is possible to overcome this. I also have some string variables. Is it possible to say Stata to keep the string variables only for the one firm that continues to carry the firm name after the merger (i.e. Firm 2)?
Von: Eric Booth <[email protected]>
> On Mar 26, 2012, at 9:35 AM, [email protected] wrote:
>> I have two firms in a data set that merge at a given point of time. For a specific reason, I need to sum the observations over their balance sheet items in each period of time. Would that be possible in Stata?
>>
>>
>> The dataset looks like that:
>>
>> Firm Date Item1 Item2 Item3
>>
>>
>> Firm1 Date1 Item1 Item2 Item3
>>
>> Firm2 Date1 Item1 Item2 Item3
>>
>> Firm3 Date1 Item1 Item2 Item3
>>
>> ...so on.
>>
>
> If you want to add across item1-item3, then:
>
> egen sum = rowtotal(Item1-Item3)
>
> will do it. See -help egen-.
>
>
>
>
>
>> I would like to merge in each period of time the data for firm 1 and firm 2 so the dataset will look like that:
>>
>>
>> The dataset looks like that:
>>
>> Firm Date Item1 Item2 Item3
>>
>>
>> Merged_Firms Date1 Item1 Item2 Item3
>>
>> Firm3 Date1 Item1 Item2 Item3
>>
>
>
> I think you are asking how to -collapse- just Firms 1 and 2 in each year of your dataset. This example would need to be expanded to account for the total # of Firms you have in your data and how you want to -collapse- them, but it reproduces your example table above:
>
> **********
> clear
> inp firm date item1
> 1 2007 45
> 2 2007 50
> 3 2007 99
> end
>
> g collapseind = 1 if inlist(firm, 1, 2)
> replace collapseind = 0 if mi(collapseind)
>
> collapse (sum) item1, by(collapseind date)
> lab def x 0 "Firm 3" 1 "Merged Firms"
> lab val collapseind x
> li
> **********
>
>
> -Eric
>
>
> __
> Eric A. Booth
> Public Policy Research Institute
> Texas A&M University
> [email protected]
> +979.845.6754
>
>
*
* 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/