When building targeting segments using the AND and OR nodes, users have a choice between two rules that are used to process a node’s counts. This year, a new setting was released for Business Contexts where a “default” can be set between the two 2 available rule methods.
This Business Context default setting is somewhat new, but the actual rules available in the AND and OR nodes are not new. The default now makes it easier for some customers to ensure they use the correct method.
These two rule methods could provide the same results, or different results depending on the data being processed. Let’s take a look at the difference between these two available methods and how to set the default for a business context.
The Two Rules
Here are the two options for the AND node rule:
Here are the two options for the OR node rule:
Let’s explore an example of an AND node to see how it is possible to get different counts between the two methods. This is a simple example where we want an AND node to be populated with Household subjects that contain at least one customer subject that is female and age>30:
Select any image to see a larger version.
Mobile users: To view the images, select the "Full" version at the bottom of the page.
The first rule Meets all conditions defined by input nodes as already stated works the same way that a logical AND works. So a household will be included in the count if it has a least one customer that is BOTH female and age>30. So to make it very clear, if a household contains only one customer that happens to be female and age 25, that household will not be counted.
The screenshot above shows the result of using this first rule: 78,861 Households.
The second rule Is a member of each group defined by input nodes as stated works like a SQL intersect command. This rule works different in that it will count a household in our example if:
Here is an important point: the two rules could produce different counts if you are using aggregated data. In this example, we are using Households as the subject. A household can contain multiple customers with various values for both age and gender. This “many to one” relationship between customer and household subjects is what can yield different results depending on which rule is applied.
If the rules produce different counts, the second rule will always produce a higher number because it will count the exact same as the first rule, plus any additional (households in this example) that meet the criteria that works like an SQL intersect command. In this example, that proved true – by changing the AND node rule to the second rule and re-running an update of the counts – this produced a higher number of 80,348 households:
Default Within Business Context Settings
To set the default rule, use the Business Context Settings tab->Options to select a rule such as below for the AND node (hint: the ? in the UI provides a nice pop-up summary of how this works):
Please note it will be recorded in the Audit Log if a user changes the default method in the Business Context Settings.
For more details and information on building segments using AND and OR nodes in SAS 360 Direct, please visit these sites below:
Courses:
Find more articles from SAS Global Enablement and Learning here.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
The rapid growth of AI technologies is driving an AI skills gap and demand for AI talent. Ready to grow your AI literacy? SAS offers free ways to get started for beginners, business leaders, and analytics professionals of all skill levels. Your future self will thank you.