PROC Report where bases on calculated column

[Ronein]

Hello

I want to print in proc report only rows with BMI between 19 and 21

What  is the way to do it?

proc report data=sashelp.class nowd;  
column name weight height BMI; 
define name / display; 
define weight / display; 
define height / display;
define bmi / computed format=4.1 'BMI';  
compute bmi;    
bmi = weight/(height*height)*703;
endcomp;  
run;

[Kurt_Bremser]

Apply the same formula in a WHERE= dataset option or a WHERE statement.

proc report
  data=sashelp.class (where=(19 le weight/(height*height)*703 le 21))
  nowd
;

[Ronein]

Thanks,

Is there a way to perform it with related to the computed column ?

In complicated cases the  computed column is not simple calculation and then it will be difficult to apply it in such way 

[Kurt_Bremser]

Calling @Cynthia_sas if this is possible.

[Ronein]

How can I ask her?

[Cynthia_sas]

Hi:
Unfortunately, PROC REPORT will not do what you want to do. When you are computing a column, the report row is already built and the other columns populated, so you're asking PROC REPORT to both build the report row and then suppress the same report row based on the value of the computed column.
@Kurt_Bremser's solution to use a WHERE or to pre-process the data in a DATA step before the PROC REPORT step are the only solutions in this case.
Cynthia

[Kurt_Bremser]

Thank you for the clarification!

I was not sure if there might be a trick to achieve this buried in PROC REPORT.