Create a custom sort order

[unnati]

Hello,

Can anyone help me to re-order my value in this dataset. I want my "Q1,Q3" before "min,Max" value in variable  _SUBVARLBL_.  

[Reeza]

You'll have to add some variables to control the ordering.
Map N=1, mean=2, SD=3, ... Q1,Q3 = 5, min/max=6 and anything else 0.

Then sort by _VARVAL_ and the new variable created with the numbers.

[unnati]

can you provide me answer with code Please ??

Thank you

[Reeza · Accepted solution]

data _temp;
set have;

if compress(_subvarlbl_) = 'n' then order_var=1;
else if compress(_subvarlbl_) = 'Mean' then order_var=2;
.....

else order_var = 0;

run;

proc sort data=_temp;
by _varval_ order_var;
run;

Here's the idea, you can code the remaining groups as needed. I used COMPRESS() on the strings because it appears you have leading spaces and this will remove them.  Be careful with COMPRESS() and text with hyphens or comma's though.

---

@unnati wrote:

Hello,

Can anyone help me to re-order my value in this dataset. I want my "Q1,Q3" before "min,Max" value in variable  _SUBVARLBL_.  

---