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]

From |
Nick Cox <njcoxstata@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: ranking variables on the basis of total values of observations |

Date |
Wed, 28 Mar 2012 20:34:58 +0100 |

As far as I can see this could mean several things. I am not clear that when you say "rank" you don't mean "order" instead. I don't think you want -rowranks- (SSC). Why not just give us a toy dataset, with say 5 observations and 5 variables, and what you want to change it to? Then it should be easier to see what you want. By the way, adding lots of blank lines just makes your posts more difficult to read. I've edited what came in. Nick On Wed, Mar 28, 2012 at 8:22 PM, tashi lama <ltashi32@hotmail.com> wrote: > > I have a list of variables and I would like to rank the variables or any given variable for that matter on the basis of total values of their observations. I thought of approaching this problem in the following way. > > 1. find the running sum of all the variables using generate or the total using egen although I think I would prefer generate. > > say there are var1 var2 var3 > > gen tvar1=sum(var1) > gen tvar2=sum(var2) > gen tvar3=sum(var3) > > 2. then compare tvar1, tvar2 and tvar3 using if conditions. > > Once this is done, I would like to expand such that I can rank those variables but for given period of time. And this is essentially why I think generate sum is better for this problem because it is a running sum. > say date var1 var2 var3 > > I would like to be able to rank variables say for 01jan2011 to 01feb2011 and so on. > > Has anyone worked in this kind of problem before or does anyone have any idea or thought regarding this problem? Any help or lead would be highly appreciated? I saw that there is a stata module rowranks to calculate ranks in a row but i don't know how can it be useful to me. Most probably not.... * * 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 variables on the basis of total values of observations***From:*tashi lama <ltashi32@hotmail.com>

**Re: st: ranking variables on the basis of total values of observations***From:*Nick Cox <njcoxstata@gmail.com>

**References**:**st: ranking variables on the basis of total values of observations***From:*tashi lama <ltashi32@hotmail.com>

- Prev by Date:
**st: ranking variables on the basis of total values of observations** - Next by Date:
**Re: st: ranking variables on the basis of total values of observations** - Previous by thread:
**st: ranking variables on the basis of total values of observations** - Next by thread:
**Re: st: ranking variables on the basis of total values of observations** - Index(es):