Hi! I have what I hope is a pretty easy question to answer for the pros out there that I have been unable to figure out today. I am working with data on crop incomes and areas cultivated. I have generated a new variable for each crop which is basically income/area, let's call it xprof where x is the name of the crop. I am trying to find a way to generate the means each xprof variable and sort them. Basically, I am trying to generate a sorted list of which crops generate the most income based on the land they use.
I have been playing around with this a bit and can't seem to figure out a way to sort them since the normal sort functionality only sorts within a single variable. I am working with over 100 crops/xprof variables so an efficient way of doing this would be much appreciated. Thanks!