Sorting Variables within Cases

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

Sorting Variables within Cases

Erin Miles
Below are a couple of correspondences in regards to a question that I am
needing help with.  The way that Gene ordered the data set is exactly how I
need to sort mine.  Also, we can assume that all the variables that I need
to sort within cases are numeric.  Thank you!  Erin Miles

This is Erin's reply to my questions sent last week about her posting.

>>The sort command will only allow me to sort ALL of the data set by one
variable.  I need to sort the variables from highest to lowest for each
case.  I haven't been able to find a command that allows this.  Hopefully
this makes my problem a bit easier to understand and hopefully you can help
me.  Maybe I am not seeing an option of sort that you are aware of.  Thanks
for your time! Erin

Erin, I think I understand what you want. Suppose this is your dataset.

ID x1 x2  y  z
01 27 23  4  9
02 18  2 24 50
03  3 17  4 13

Do you want it to look like this when the sorting is finished?   YES

ID x1 x2  y  z
01 27 23  9  4
02 50 24 18  2
03 17 13  4  3

If not, please arrange it correctly in your reply. Can we assume that all
variables whose values are to be sorted within case are all either string or
numeric? Lastly, please reply to the list because I can think of two people
who have posted on this subject in the recent past.

Gene Maguin

_________________________________________________________________
Get free, personalized commercial-free online radio with MSN Radio powered
by Pandora http://radio.msn.com/?icid=T002MSN03A07001