Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS Visual Analytics | To Identify Duplicates in a column

Accepted Solution Solved
Reply
Contributor
Posts: 28
Accepted Solution

SAS Visual Analytics | To Identify Duplicates in a column

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.

 


Accepted Solutions
Solution
‎01-22-2018 06:34 AM
Contributor
Posts: 30

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

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

 

 

View solution in original post


All Replies
Contributor
Posts: 30

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

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?

Contributor
Posts: 28

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

Posted in reply to utrocketengineer

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

Solution
‎01-22-2018 06:34 AM
Contributor
Posts: 30

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

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

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 273 views
  • 0 likes
  • 2 in conversation