topic Duplicate issue? - Finding the difference in the duplicate IDs. in SAS Programming

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

ybz12003 — Wed, 12 Feb 2020 15:58:25 GMT

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.

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

Reeza — Wed, 12 Feb 2020 16:02:45 GMT

More details.

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

Krueger — Wed, 12 Feb 2020 16:21:48 GMT

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

https://documentation.sas.com/?docsetId=sqlproc&docsetTarget=p1nlqenp6yoyitn1tbz095cbvxt3.htm&docsetVersion=9.4&locale=en

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

ybz12003 — Wed, 12 Feb 2020 16:30:22 GMT

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

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

Krueger — Wed, 12 Feb 2020 16:41:55 GMT

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-duplicate-values/td-p/397950