topic Re: Two combinations of a unique ID in SAS Enterprise Guide

Two combinations of a unique ID

Dogo23 — Wed, 17 Jan 2018 16:52:40 GMT

Hello,

If I want to select a unique record by ID (mid), and I have two combinations of the ID, how do I pull that from a single table?

Thanks

Re: Two combinations of a unique ID

novinosrin — Wed, 17 Jan 2018 16:54:53 GMT

which one do you need to pick from communication_nm as i see those are two different values?

Re: Two combinations of a unique ID

Reeza — Wed, 17 Jan 2018 16:58:36 GMT

What do you mean by 2 combinations?

Why doesn't a straightforward WHERE condition work?

where mid = 'M12341234';

Re: Two combinations of a unique ID

Dogo23 — Wed, 17 Jan 2018 22:08:02 GMT

Good question, it's because there are other ID's from that table that will need to be pulled as well. That's why I can't specify one unique ID in a where statement.

Re: Two combinations of a unique ID

Dogo23 — Wed, 17 Jan 2018 22:10:11 GMT

It really doesn't matter, it could be random or based on date/time. This is occurring because someone submitted this campaign from an application twice (which is why the ID remains the same), but changed the name of the communication.

Re: Two combinations of a unique ID

Reeza — Wed, 17 Jan 2018 23:16:09 GMT

Try PROC SORT with the NODUPKEY option.