Hi All,
Based on filters can we hide and show columns which are present in cross tab.
Please provide the code that creates the cross tab, and tell us which columns you do not want, and the logic for filtering them out.
Providing usable source data (data step with datalines) will most probably speed up the process of finding a useful answer.
I moved your question to the Visual Analytics community. Since I do not use that product, I won't be of much help here.
Hello,
I don't think you can hide the entire column (including the column heading.)
What you can do is make all of the values missing, which will cause the table/crosstab to aggregate as if the column were not there.
Here is a nonsense example with SASHELP.CARS:
Let's say we want to ignore the Drivetrain column when "Asia" is selected in the button bar.
First we make a character parameter and assign it to the button bar.
Then we create a calculated item that uses that parameter:
IF ( 'Parameter 1'p NotIn ('Asia') ) RETURN 'DriveTrain'n ELSE ''
Now when we select "Asia" in the button bar, we get this:
If you want the button bar to ONLY set the parameter and not also filter the data, be sure to place the button bar in the body of the report page and not in the prompt area. That would give this result, which might be closer to what you wanted:
It's not exactly what you are looking for, but I hope this might help.
Thanks,
Sam
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 16. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.