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.
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:
Let me know if you have any questions.
Best regards,
Petri
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.