BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
es_edu
Fluorite | Level 6

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.

1 ACCEPTED SOLUTION
3 REPLIES 3
es_edu
Fluorite | Level 6

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

sbxkoenk
SAS Super FREQ

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

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 1363 views
  • 1 like
  • 3 in conversation