SAS Visual Analytics | To Identify Duplicates in a column

[narulap]

Hello,

Is there any function in SAS VA 7.4 to identify Duplicates in a column and print them.

I used distinct count for the unique values but need to identify the duplicates.

[utrocketeng]

if you are trying to list duplicate values ... say in a list table ... can you use the frequency column and then filter where the frequency is > 1?

[narulap]

Hi, 

Thanks for the response.

I can add the frequency column in a list but I cannot add the filter on it.

I applied display rule on Frequency > 1 but it just highlights the rows which are having duplicates but I need to display the list of duplicates.

Regards,

Pankaj

[utrocketeng · Accepted solution]

i loaded a dataset to VA with 100 observations. i left one blank. here is my list table .  in the filters option, i added frequency and changed the lower limit to 2,  .  that filtered my table,