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

From |
"Eva Poen" <eva.poen@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

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

Date |
Tue, 30 Sep 2008 15:55:29 +0100 |

OK, but didnt' you receive the email (direct or digest)? Here are the archives of statalist: http://www.stata.com/statalist/archive/. Please also see the statalist faq, where this is mentioned. You can click on a month to see a list of messages in that month, or type in a search keyword. The link to my answer on Saturday is http://www.stata.com/statalist/archive/2008-09/msg01276.html . Eva 2008/9/30 Bastian Steingros <Steingros@gmx.de>: > 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/ * * 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/

**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>

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

- Prev by Date:
**Re: st: genhw error message** - Next by Date:
**Re: st: how to open very large txt files (>6G)** - Previous by thread:
**Re: st: benchmarking + determine the peers** - Next by thread:
**RE: st: Fraud methods in Stata,** - Index(es):

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