Use formatted value in where statement

[JHenkel]

I would like to use formats to group values and then select one of the formed groups with a where statement.

Consider the following simple code:

proc format;
      value enginesSML
            low-2 = 'Small'
            2-3 = 'Medium'
            3-high = 'Large';
run;

data tmp;
      format engines enginesSML.;
      set sashelp.cars(keep=engineSize);
      engines = engineSize;
run;


proc print data=tmp(obs=5);
      *where engines='Large'; /*Does not work*/
       where engines > 3; /*works*/
run;

How can I get this statement to work?

where engines='Large';

I'm on SAS 9.2.

[Kurt_Bremser · Accepted solution]

Use this:

where put(engines,enginesSML.) = 'Large';