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
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.