Returns the exclusive union of two category lists--that is, it returns all of the categories that are in either one of the category lists, but not in both.

If the current value is NULL, Val is an empty Categorical value ({}) and the return value is Answers. If Answers is NULL, the return value is Val.

This function is equivalent to the Division (/) operator for Categorical values, except that it can operate on named categories and the NULL behavior is different. However, using the / operator is generally faster than using the XUnion function.

Like the Difference and Intersection functions, XUnion is useful when categorical variables have identical or overlapping category lists. For example the biology and education variables have identical response lists. In the following example, XUnion is used to return any categories that are in either one of the category lists, but not in both, and the >= operator tests whether the result contains the Yes category. For example, you could use this expression to select respondents who chose the Yes category in response to either one of the questions, but not to both.