Use formatted value in where statement

JHenkel — Mon, 11 Sep 2017 14:00:09 GMT

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.

Re: Use formatted value in where statement

Kurt_Bremser — Mon, 11 Sep 2017 14:03:22 GMT

Use this:

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

topic Re: Use formatted value in where statement in SAS Programming

Use formatted value in where statement

Re: Use formatted value in where statement