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: how to save summarize data
From
Sabrina Carrossa <[email protected]>
To
[email protected]
Subject
Re: st: how to save summarize data
Date
Sat, 19 Jun 2010 18:00:44 +0200
I am not sure that the following is the best solution, but it works.
Let's suppose that the variable "companies" is a numeric one (i.e.
from 1 to 10).
gen EFNmean=.
forevalues c= 1/10 {
summarize EFN if companies==`c'
replace EFNmean=r(mean) if companies==`c'
}
sabry
On 19 June 2010 17:21, Thomas Gericks <[email protected]> wrote:
> Hello,
>
> I am working with panel data. I am analyzing several companies over a time period.
>
> I generated a variable indicating the capital structure (EFN) of the company for every year.
> Now I want to have the mean per company over the time period.
>
> I know how to get it but i want to save the mean as a new variable.
>
> A way to read it is:
>
> bys company, summarize EFN
>
> how can i now save it as a variable for every company?
>
>
> Thanks a lot for your help,
>
> Thomas Gericks
>
>
> ___________________________________________________________
> WEB.DE DSL ab 19,99 Euro/Monat. Bis zu 150,- Euro Startguthaben und
> 50,- Euro Geldprämie inklusive! https://freundschaftswerbung.web.de
>
> *
> * 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/
>
--
sabrina
*
* 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/