Desktop productivity for business analysts and programmers

Two combinations of a unique ID

Reply
Contributor
Posts: 55

Two combinations of a unique ID

 

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?

 

Capture.PNG

 

Thanks

 

 

 

PROC Star
Posts: 1,328

Re: Two combinations of a unique ID

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

Contributor
Posts: 55

Re: Two combinations of a unique ID

Posted in reply to novinosrin

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. 

Super User
Posts: 22,850

Re: Two combinations of a unique ID

Try PROC SORT with the NODUPKEY option.

Super User
Posts: 22,850

Re: Two combinations of a unique ID

What do you mean by 2 combinations?

 

Why doesn't a straightforward WHERE condition work?

 

where mid = 'M12341234';
Contributor
Posts: 55

Re: Two combinations of a unique ID

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. 

Ask a Question
Discussion stats
  • 5 replies
  • 164 views
  • 2 likes
  • 3 in conversation