How MISSING / SPACE and NULL values are treated and how to select them in SAS Customer Intelligence Studio:
Depending on the underlying database MISSING and/or SPACE are defined differently. MISSING can contain a dot '.' where SPACE can contain a blank " ".
When using Metadata=VALUES and AllowBlankValue=True as a custom attribute in your Information Map, you are able to select either [Missing] or [Space] from the list of “Select Values” in a select node as shown in the screenshot below:
You cannot select empty string from within SAS Customer Intelligence Studio.
AllowBlankValue is an option you can set in your Information Map but it only works when:
Have a look at the explanation below how NULL or BLANK values are treated in SAS Customer Intelligence:
If you are generating MA Metadata (SAS Datasets), then:
- “” (empty string) is not supported as a selection criteria value, and it may show up in MA Metadata counts as “Missing” because SAS treats “” and NULL as the same value, regardless of what the underlying database supports.
- AllowBlankValue is meant to allow us to support “ “ - a string with a single blank value in it.
If you need to select “” (empty strings) the only possibility is to select all values for this specific data item and then check the rule “No value meets these criteria”:
or create a process node with the appropriate SQL statements.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.