Greetings Community, I have this dataset: Client_ID Address ABC123 11 East Street, City1, OH ABC123 11 East Street, City1, OH County 5 XFE51D 100 Main Street, City2, OH XFE51D 100 Main Street, City2, OH I need to keep only ONE observation for each client with the following conditions: - If the addresses are different, keep the longest address - if the addresses are the same, keep only one. My final dataset should look like this: Client_ID Address ABC123 11 East Street, City1, OH County 5 XFE51D 100 Main Street, City2, OH Thank you!
... View more