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.
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.
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.
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:
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.
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.