PROC REPORT for multiple parameter

[mnithinshetty]

Hi All,

 In table output there around 40 columns to be displayed based on parameters.
for one param there will be few columns with no values
and the same columns will be having values for an another param.
so we cannot avoid those columns in paging. but the task is we should not print columns with no values for any parameter
and if the same column has values for other parameter then it should be displayed for that specific param.

Can someone please provide suggest me the logic 

[andreas_lds]

I think you will have to pre-process the data.

Posting an excerpt of the data and the proc report you have will allow better suggestions.

[RichardDeVen]

A variable (your parameter ?) having columns for values in output suggests you are using

define parameter / across;

Is this the case ?

Are you stacking across variables ?

columns group (parameter1,parameter2);
define group / group;
define parameter1 / across;
define parameter2 / across;

Is this the case ?  If so, you might want a WHERE statement added to the PROC step.