[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Steven Samuels <sjhsamuels@earthlink.net> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: ranking with weights |

Date |
Tue, 2 Dec 2008 13:53:40 -0500 |

-Steve On Dec 2, 2008, at 12:54 PM, Cindy Gao wrote:

HelloI am trying to find a way to rank weighted data (since the egenfunction -rank- does not work with weights). A simple way would beorder the data in terms of variable that I have interest in(monthly expenditure) and then create a new variable like -grank1=sum(weight)-. But, there is problem. Some of my observationsare "tied" as they have the same level of expenditure. Using thesimple method I mention means that some observations are rankedabove others even though they have same level of expenditure. Thisis a problem as the weights are large so you find that 2observations are ranked with bug gap in between even though samelevel of expenditure. It is even bigger problem because the weightsmight be correlated with some other variables I am interested in(like region, since some regions are less sampled than other). Ialso try multiplying the expenditure ranking by the weight, butthis gives wrong results (for example they do not add up to weightedtotal). Can anyone help? In other words, I would like for allobservations with same expenditure to have same rank, which Iassume would be some average of all the weighted observationshaving that same expenditure. I include a sample dataset below:expenditure weighting rank rank1 weighted_rank10 341 1 34134112 1065 2.5 1406 ??? 12 98 2.5 1504 15 254 4 1758 ....... thanks, Cindy * * 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/

**Follow-Ups**:**Re: st: ranking with weights***From:*Cindy Gao <cindy.gao@ymail.com>

**References**:**st: ranking with weights***From:*Cindy Gao <cindy.gao@ymail.com>

- Prev by Date:
**st: RE: Interpretation of Log Transformed Independent Variables in Ordered Logit** - Next by Date:
**st: duration models-random dates as covariates** - Previous by thread:
**st: ranking with weights** - Next by thread:
**Re: st: ranking with weights** - Index(es):

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