topic Re: How to sort the data with I II III ? in SAS Programming

How to sort the data with I II III ?

daisy6 — Wed, 29 Nov 2017 15:22:12 GMT

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!

Re: How to sort the data with I II III ?

data_null__ — Wed, 29 Nov 2017 15:38:40 GMT

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

Re: How to sort the data with I II III ?

daisy6 — Wed, 29 Nov 2017 15:42:08 GMT

Thank you Data_null_. That is what I want!

Re: How to sort the data with I II III ?

RW9 — Wed, 29 Nov 2017 15:46:48 GMT

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;