Good day everyone,
I hope someone can help me with this issue. I have looked at a few posts and I am not sure if I am missing the language used (terms) or something just doesn't work. I have cross tabs in several reports that that users need to export "Formatted Data" data from. I must restrict the option for "Detailed Data".
I have read where you can use a post-aggregate filter such as frequency percent, but that will restrict my results and I am not sure how you do that since I attempted to do that as a test. I have also heard of applying a filter on a custom category which I have attempted repeatedly without success. Maybe I am misunderstanding the terms.
Here is the scenario, I have a crosstab in a report that provides summary data. I need for users to be able to export that summary data, the "Formatted Data", but not be able to export the "Detailed Data" which would include information we do not want a user to access (personal IDs for example), and there are also many, many columns. There are other tabs in the report that use the personal ID values so I cannot exclude them. I did attempt to add a dummy ID and filter to exclude that, but that did not work either.
I have attached a PDF of the crosstab. As you can probably tell, there is a lot of data "behind the scenes" that creates this information that we do not want to be available for export.
I understand there may be reasons, but I am thinking this should be a really simple option or process.
Thank you,
Gary
The SAS Tech solutions below do not work for us. For some cases the aggregate value "Frequency Percent" does not exist in the "Data" tab so we cannot use it.
The "Show or Hide" option may work, but not for us. A single dataset may run several reports therefore hiding a field may cause issues with another report or one developed in the future.
The "Rank" option as described below would work until you added additional data to the dataset increasing the number of rows, but, we did discover that if we set the Rank's "Top Percent" value to 100 the "Detailed Data" option did indeed disappear.
SAS Tech solution;
The SAS Tech solutions below do not work for us. For some cases the aggregate value "Frequency Percent" does not exist in the "Data" tab so we cannot use it.
The "Show or Hide" option may work, but not for us. A single dataset may run several reports therefore hiding a field may cause issues with another report or one developed in the future.
The "Rank" option as described below would work until you added additional data to the dataset increasing the number of rows, but, we did discover that if we set the Rank's "Top Percent" value to 100 the "Detailed Data" option did indeed disappear.
SAS Tech solution;
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.