[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
"Bastian Steingros" <Steingros@gmx.de> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: benchmarking + determine the peers |

Date |
Tue, 30 Sep 2008 16:48:17 +0200 |

Dear Eva, I can not find my posted example on the Internet, so I thought the mail did not reach you and your colleagues. How can I see my question in the Internet? I mean how can I see a website like: http://www.stata.com/statalist/archive/2007-10/msg00807.html When entered my name and the keyword stata or peer in google, I have found nothing... Markus -------- Original-Nachricht -------- > Datum: Tue, 30 Sep 2008 15:41:49 +0100 > Von: "Eva Poen" <eva.poen@gmail.com> > An: statalist@hsphsun2.harvard.edu > Betreff: Re: st: benchmarking + determine the peers > You posted exactly the same question on Saturday, and I replied. If > you still have problems, tells us where exactly. > > Eva > > > 2008/9/30 Bastian Steingros <Steingros@gmx.de>: > > Dear Stata users, > > > > I am searching a function in stata to program peer groups. > > In my benchmarking study about American industries I want to compare > companies by its sales, earnings etc. > > I use the three digit industry code to classify the industries > (sic-codes). The peer group must be within the same industry. > > Here, the purpose is to compute the mean or median of the sales and to > see if the respective firm's performance is below or above the mean or the > median. > > > > But, the peer group of firm X contains all the companies with the same > digit code but *not* firm X (otherwise I would compare X with itself) > > > > To conclude: > > > > year sic-code firm sales mean median > > 1990 333 X 10 ? ? > > 1990 333 Y 20 ? ? > > 1990 333 Z 30 ? ? > > --------------------------------------------- > > 1990 334 A 21 ? ? > > 1990 334 B 5 ? ? > > --------------------------------------------- > > 1991 etc. ... > > > > so, in 1990 > > the peer group mean/median for X must contain (20+30) but not 10 > > the peer group mean/median for Y must contain (10+30) but not 20 > > the peer group mean/median for Z must contain (10+20) but not 30 > > and so on... > > > > is there a way to program is stata something like: > > > > by year sic-code, sort: egen median/mean *without the sales of the firm > X / firm Y etc.* > > > > (Please note, it is basically more important for me to obtain the > *median* than the mean peer group due to the outlier problem of the mean > function.) > > > > So, please help me find a solution to the median peer group first. > > > > Many thanks in advance! > > > > Bastian > * > * 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/ -- GMX Kostenlose Spiele: Einfach online spielen und Spaß haben mit Pastry Passion! http://games.entertainment.gmx.net/de/entertainment/games/free/puzzle/6169196 * * 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/

**Follow-Ups**:**Re: st: benchmarking + determine the peers***From:*"Eva Poen" <eva.poen@gmail.com>

**References**:**st: benchmarking + determine the peers***From:*"Bastian Steingros" <Steingros@gmx.de>

**Re: st: benchmarking + determine the peers***From:*"Eva Poen" <eva.poen@gmail.com>

- Prev by Date:
**Re: st: benchmarking + determine the peers** - Next by Date:
**Re: st: genhw error message** - Previous by thread:
**Re: st: benchmarking + determine the peers** - Next by thread:
**Re: st: benchmarking + determine the peers** - Index(es):

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