topic SAS Visual Analytics | To Identify Duplicates in a column in SAS Visual Analytics

SAS Visual Analytics | To Identify Duplicates in a column

narulap — Thu, 18 Jan 2018 13:25:17 GMT

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.

Re: SAS Visual Analytics | To Identify Duplicates in a column

utrocketeng — Thu, 18 Jan 2018 13:48:41 GMT

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?

Re: SAS Visual Analytics | To Identify Duplicates in a column

narulap — Thu, 18 Jan 2018 15:30:58 GMT

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

Re: SAS Visual Analytics | To Identify Duplicates in a column

utrocketeng — Thu, 18 Jan 2018 15:56:21 GMT

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,