Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

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

 From Nick Cox To statalist@hsphsun2.harvard.edu Subject Re: st: ranking variables on the basis of total values of observations Date Wed, 28 Mar 2012 20:37:35 +0100

```On Wed, Mar 28, 2012 at 8:34 PM, Nick Cox <njcoxstata@gmail.com> wrote:
> 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/
```