topic Retain group variable is different then keep both records , else if group='Other' then keep only tis in SAS Programming

Retain group variable is different then keep both records , else if group='Other' then keep only tis

Stalk — Tue, 08 Dec 2020 01:43:34 GMT

I have a specific requirement. Keep all the duplicate records if the group is different except in one instance If the record is unique with Group='Other' then keep this otherwise delete all duplicate records where group='Other'. Always take the most recent subDate

Re: Retain group variable is different then keep both records , else if group='Other' then keep only

andreas_lds — Tue, 08 Dec 2020 07:56:08 GMT

Maybe this is a late-monday-effect (had a day off yesterday): i don't see a clear definition of "duplicate" in your description.

Re: Retain group variable is different then keep both records , else if group='Other' then keep only

Stalk — Tue, 08 Dec 2020 14:42:03 GMT

Duplicates are across the multiple fields unitName, ADDR1,group;
If a record is unique and GROUP='Other' then keep
If a record is a duplicate and GROUP='Other', then delete that one.

Re: Retain group variable is different then keep both records , else if group='Other' then keep only

andreas_lds — Wed, 09 Dec 2020 06:44:31 GMT

@Stalk wrote:
Duplicates are across the multiple fields unitName, ADDR1,group;
If a record is unique and GROUP='Other' then keep
If a record is a duplicate and GROUP='Other', then delete that one.

And what should happen to those observations with Group NE 'Other'?