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-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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
  • 1809 views
  • 1 like
  • 3 in conversation