How to sort the data with I II III ?

[daisy6]

Hello, I have a dataset with variable part

data test;

input part $16.;

datalines;

MD-III_3BQ

MD-II_3BQ

MD-I_3BQ

MD_3BQ

SG-III_5AP

SG-II_5AP

SG-I_5AP

SG_5AP

;

run;

The output I want is the follows:

MD_3BQ

MD-I_3BQ

MD-II_3BQ

MD-III_3BQ

SG_5AP

SG-I_5AP

SG-II_5AP

SG-III_5AP

when I use proc sort, I did not get what I want? Could anyone help me? Thanks!

[data_null__ · Accepted solution]

proc sort sortseq=linguistic(numeric_collation=on);
   by part;
   run;

[daisy6]

Thank you Data_null_. That is what I want!

[RW9]

I can't see a logical way of sorting that data, my advice would be to create either a numeric order variable, or create a format (some people like formats for this type of thing, me I avoid catalogs as much as possible).  So either:

data test;
  set test;
  select (part);
    when ("MD-III_3BQ") seq=...;
    when...
  end;
run;

Or:

proc format;
  value $prt
    "MD-III_3BQ"=...
    "MD-II_3BQ"=...
  ...
  ;
run;

data test;
  set test;
  ord=input(part,$prt.);
run;