Good Monday Community, I HAVE the following customers data, which is not sorted (I am sorting it here just to get the concept across): ID_1 ID_2 State A123456 1ABCDE FL A123456 1ABCDE GA B984536 2HGJHW NC C567342 3KJEWG IL C567342 4UYMVS IL D723410 5PPOAD WY D723410 6NNTGC AL I need to create a variable that identify the TYPE of duplicates in my data, so that I can deal with them accordingly. As you can tell from the above, that there are four types of duplicates as in the WANT data below: ID_1 ID_2 State Type A123456 1ABCDE FL Same IDs, Different States A123456 1ABCDE GA Same IDs, Different States B984536 2HGJHW NC Unique C567342 3KJEWG IL Same ID_1 and State, Different ID_2 C567342 4UYMVS IL Same ID_1 and State, Different ID_2 D723410 5PPOAD WY Same ID_1, Different ID_2 and State D723410 6NNTGC AL Same ID_1, Different ID_2 and State I run my code in SAS EG using Proc SQL, and I appreciate any help Many thanks!
... View more