topic PROC REPORT for multiple parameter in SAS Programming

PROC REPORT for multiple parameter

mnithinshetty — Wed, 23 Sep 2020 06:14:37 GMT

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

Re: PROC REPORT for multiple parameter

andreas_lds — Wed, 23 Sep 2020 07:00:12 GMT

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.

Re: PROC REPORT for multiple parameter

RichardDeVen — Wed, 23 Sep 2020 11:44:14 GMT

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.