topic Customer Intelligence Studio 6.6: Alternative to SQL MINUS on Campaign Diagram in SAS Customer Intelligence

Customer Intelligence Studio 6.6: Alternative to SQL MINUS on Campaign Diagram

Eitan123 — Mon, 18 Oct 2021 13:09:20 GMT

Hey,

This topic's for an implementer, so there must be no SAS code involved:

As seen in the following picture, I have two select blocks. One containing populations X1 and X2, and another containing a sub group of X1.
Eventually, I need to hold X2 and the sub group of X1 in the same block.
I have no way to distinguish between X1 and X2 (they are just a list of ID's).
Is there a way to remove the population of sub X1?

Generally, in SQL I'd write:
select ID from X1
union
select ID from X2
minus
select ID from subX1

Re: Customer Intelligence Studio 6.6: Alternative to SQL MINUS on Campaign Diagram

JamesAnderson — Tue, 19 Oct 2021 00:10:37 GMT

Hi Eitan123,

If I understand your question correctly (you want to remove subX1 from X1plusX2) then you can use the Prioritize Node for this. Add a Prioritize Node to the diagram, connect "subX1" then connect "X1+X2". Done. When you run the prioritize node subjectIds that exist in both groups will first be placed into subX1 and not into "X1+X2". What remains of "X1+X2" are only those subjectIDs that were not in your "subX1".

Regards

James