topic Re: Creating and displaying text for suppressed values in numeric-driven visuals. in SAS Visual Analytics

Creating and displaying text for suppressed values in numeric-driven visuals.

es_edu — Thu, 14 Nov 2024 17:03:28 GMT

Good morning,

I'm building a SAS Viya dashboard that shows numeric visuals such as bar charts, line-graphs, etc. For example, I may create a bar chart that shows how many people are in each racial subgroup. In my visuals, some data cannot be displayed because it could potentially identify people in the dataset. I'm trying to find a way to:

Still includes a suppressed category (but does not show data). Preferably, a data value that has been suppressed will be set to 0.
Identify to users that data isn't showing for a given category because it has been suppressed (reason code).

I pre-aggregate and apply suppression rules on the back end (rather than letting SAS do any aggregations). In order to abide by our suppression policies, any row that should NOT show on the dashboard is coded in the data as follows (all metrics are non-negative):

-0.10 - Low N Count
-0.13 - Complementary Suppression
-0.05 - Top/Bottom coding

At present, I'm just not displaying any suppressed data; however, this is causing confusion for data viewers. I'm looking for a way to indicate that data isn't showing because of suppression issues, rather than something that is wrong with our calculations.

Re: Creating and displaying text for suppressed values in numeric-driven visuals.

TSBruce — Thu, 14 Nov 2024 18:13:06 GMT

Visual Analytics provides the capability to suppress data items if individual values could easily be inferred. Here are a couple of links that might be helpful:

https://go.documentation.sas.com/doc/en/vacdc/v_029/vareportdata/p1vsphor4qnevcn13p4bepmj5wwx.htm#p0bxfqr5s1ncvnn1hw1xfln6b61n

https://go.documentation.sas.com/doc/en/vacdc/v_029/vareportdata/p0v59n8i9x7tggn0zi0jgirzkghw.htm#n00r6z7qf9pgh8n18zj5ohkpeors

Re: Creating and displaying text for suppressed values in numeric-driven visuals.

sbxkoenk — Thu, 14 Nov 2024 18:38:29 GMT

This is like Statistical Disclosure Control (SDC) !

You might want to look into the cell key method for protecting (Census) data.

Or this approach (an alternative method) :

Paper 1603-2014 Data Coarsening and Data Swapping Algorithms

Tom Krenzke, Katie Hubbell, Mamadou Diallo, Amita Gopinath, Sixia Chen

Westat, 1600 Research Blvd, Rockville MD, 20850

https://support.sas.com/resources/papers/proceedings14/1603-2014.pdf

BR, Koen

Re: Creating and displaying text for suppressed values in numeric-driven visuals.

es_edu — Mon, 18 Nov 2024 20:41:36 GMT

This was effective. My solution was to use SAS's Suppress() function to suppress my negative-coded values.