topic Re: PROC Report where bases on calculated column in SAS Procedures

PROC Report where bases on calculated column

Ronein — Sun, 19 Nov 2023 09:41:10 GMT

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;

Re: PROC Report where bases on calculated column

Kurt_Bremser — Sun, 19 Nov 2023 11:06:25 GMT

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
;

Re: PROC Report where bases on calculated column

Ronein — Sun, 19 Nov 2023 11:06:02 GMT

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

Re: PROC Report where bases on calculated column

Kurt_Bremser — Sun, 19 Nov 2023 11:11:09 GMT

Calling @Cynthia_sas if this is possible.

Re: PROC Report where bases on calculated column

Ronein — Sun, 19 Nov 2023 15:44:03 GMT

How can I ask her?

Re: PROC Report where bases on calculated column

Cynthia_sas — Sun, 19 Nov 2023 15:45:49 GMT

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

Re: PROC Report where bases on calculated column

Kurt_Bremser — Sun, 19 Nov 2023 17:16:10 GMT

Thank you for the clarification!

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