BookmarkSubscribeRSS Feed
Calcite | Level 5
Hi Team,
Can you please help me in colour the duplicate values using sas. Please see the attachment if index I'd is duplicate then code should compare the row and colour the non duplicate columns in duplicate rows.
Calcite | Level 5
Please see the output file here I am looking something like this . Please help
Pyrite | Level 9

Hello @shiv999 ,


I played a little with my VA 8.5 and got this as a results:


If this fits your needs fully or partially then here's how I did it. I think this should be doable also with VA8.3 and newer versions.


  1. To find the duplicate rows we will create a new data aggregation
    In the Data pane, select a data source SAS_SAMPLE. Click 

    the icon on right looking like database and then select New data from aggregation of data-source. The New Aggregated Data window is displayed. Edit it to look the same as below. The reasoning here is that we should get Frequence=1 when there is only one row with specific Index_id and tax. If the pair exist more than once then Frequency>1. We will use this in the List table to spot the duplicate rows.

  2. Now add the results from step before to original data
    Create a custom data source join to add the Frequency column to SAS_SAMPLE. In the Data pane, select a data source SAS_SAMPLE_AGGREGATED. Click the icon on right looking like database and then select New data from join with SAS_SAMPLE_AGGREGATED. Note that VA will create the Join with default settings first and you need to edit it after creation to get what we need:


  3. Finally we create rules to highlight cells in the list table
    My List table roles are as below. The variable Aggregated Frequency I have used in Hidden role is the one we created in the first step and added to SAS_SAMPLE in the data join step.

    Use display rules to highlight cells:

Let me know if you have any questions.


Best regards,




Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 2 replies
  • 2 in conversation