Duplicate issue? - Finding the difference in the duplicate IDs.

[ybz12003]

Hello,

I have a 50 variables dataset.  I found Duplicate IDs in the dataset.   But I would like to know if those Duplicates are all the same in all of the 50 variables or not?   Is there a way to do that?  Thanks.

[Reeza]

More details.

[Krueger]

The following has examples, with code on what I think you are trying to determine. 

https://documentation.sas.com/?docsetId=sqlproc&docsetTarget=p1nlqenp6yoyitn1tbz095cbvxt3.htm&docset...

[ybz12003]

i don't know which columns come with duplicate.  That's why I am trying to figout out.

[Krueger]

I'm not sure how you know there are duplicates then. Do you have some examples of what you have and actually want? 

Here's my next best guess: 

https://communities.sas.com/t5/General-SAS-Programming/How-can-I-identify-all-the-variables-with-dup...