BookmarkSubscribeRSS Feed

How to select MISSING / SPACE and NULL values in SAS Customer Intelligence Studio

Started ‎01-14-2016 by
Modified ‎01-14-2016 by
Views 2,685

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:

 

Handling_missing_values_in_SASCIS.PNG

 

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:

 

  1. You really have NULL in the data.
  2. You have configured the data item with the extended attribute "AllowBlankValue=TRUE" in the Information Map and you generate MA Metadata for this data item.

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”:

 

Select_properties_in_SASCIS.PNG 

 

or create a process node with the appropriate SQL statements.

 

Version history
Last update:
‎01-14-2016 05:14 PM
Updated by:
Contributors

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

SAS AI and Machine Learning Courses

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.

Get started

Article Tags