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: how to save summarize data


From   Sabrina Carrossa <carrossa@gmail.com>
To   statalist@hsphsun2.harvard.edu
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 <ThomasGericks@web.de> 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/


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