I am trying to get custom tables to run variables in decending order

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

I am trying to get custom tables to run variables in decending order

Björn Türoque
I have 15 individual variables that measure on a 5 point likert scale
Strongly disagree to Strongly Agree. I have created a custom table that
reports all 15 variables in one table, but I would like to have custom
tables put these variables in order so that those with the highest average
reported value are on the top of the table and those with the lowest average
are on the bottom. There does not seem to be a command for this as custom
tables runs variables in the order in which they are fed into the system and
does not offer the option of sorting the variables for you.

I have tried some syntax using vectors with the average value of each
variable to correct this problem but am unable to figure out how to solve
this problem. Any help would be appreciated.


Don