Hi,
I would like to ask this question in two parts…
1) Wondering how to sort this table based on the end portion of the variable name, in this case 'X??'
SM_A1_X11 SM_A1_X03 SM_B1_X10 SM_B1_X07 ... 5 10 2.5 5 ... 1 30 20 0.23 ... ....
To get this…
SM_A1_X03 SM_B1_X07 SM_B1_X10 SM_A1_X11 ... 10 5 2.5 5 ... 30 0.23 20 1 ... ....
2) Wondering how to sort this table based on the middle and then end portion of the variable name, in this case first sorting by 'A? and B?' and then 'X??'
SM_A1_X11 SM_A1_X03 SM_B1_X10 SM_B1_X07 ... 5 10 2.5 5 ... 1 30 20 0.23 ... ....
To get this…
SM_A1_X03 SM_A1_X11 SM_B1_X07 SM_B1_X10 ... 10 5 5 2.5 ... 30 1 0.23 20 ... ....
Thank you for your suggestions!
Best Answer