topic Create a custom sort order in SAS Programming

Create a custom sort order

unnati — Fri, 24 May 2019 16:14:38 GMT

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_.

Re: sas basic

Reeza — Fri, 24 May 2019 16:14:25 GMT

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.

Re: sas basic

unnati — Fri, 24 May 2019 16:23:13 GMT

can you provide me answer with code Please ??

Thank you

Re: Create a custom sort order

Reeza — Fri, 24 May 2019 16:39:21 GMT

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_.