BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
keiwo
Obsidian | Level 7

Greetings SASCI colleagues,

 

*** please refer to attachment for details ***

 

Diagram A ( Blue )

Diagram B ( Red )

 

Question: How do I go about excluding records from DIAGRAM A that exist in DIAGRAM B

 

Thanks,

Keith

 

1 ACCEPTED SOLUTION

Accepted Solutions
pcapazzi
Pyrite | Level 9

The end result of Diagram B should be a Cell that you name appropriately so you can easily identify it and select the option to make it Linkable. Save Diagram B.

 

In the Diagram A the end node should be a Cell. Then create a Link Node and select the cell from Digram B as the source. Then create a Prioritize node point Diagram B's cell to it first and then point Diagram A's cell to it next. Open the Priority node and check that Diagram B is in fact at the top of the priority list (matches will get pulled out) and that Diagram A's selection is second (post-suppression). Then save and execute.

 

That's one way to go about it.

View solution in original post

4 REPLIES 4
pcapazzi
Pyrite | Level 9

The end result of Diagram B should be a Cell that you name appropriately so you can easily identify it and select the option to make it Linkable. Save Diagram B.

 

In the Diagram A the end node should be a Cell. Then create a Link Node and select the cell from Digram B as the source. Then create a Prioritize node point Diagram B's cell to it first and then point Diagram A's cell to it next. Open the Priority node and check that Diagram B is in fact at the top of the priority list (matches will get pulled out) and that Diagram A's selection is second (post-suppression). Then save and execute.

 

That's one way to go about it.

keiwo
Obsidian | Level 7

Thanks pcapazzi,

 

what if both Diagrams A & B are within the same campaign.  How would I then go about to excluding records from DIAGRAM A that exist in DIAGRAM B

 

Thanks,

Keith

keiwo
Obsidian | Level 7

Hi Pcapazzi,

 

I applied your suggestion and it worked even when both DIAGRAM A & DIAGRAM B are within the same campaign diagram.

 

Much Appreciated 🙂

pcapazzi
Pyrite | Level 9

Happy to help!

How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1577 views
  • 1 like
  • 2 in conversation