How do I exclude a value from a column for Categorical Analysis

[#1]

I have a set of consumer feedback data in which the answer set for some questions was Agree Strongly, Agree Slightly, Disagree Slightly, Disagree Strongly and 'I do not have'. How do I exclude those that selected 'I do not have' in the categorical analysis (i.e. to find the total % overall that selected positively out of those that have the issue).

Hopefully that makes sense. An interactive explanation would be helpful please!

[#2 · Accepted solution]

This sort of analysis is definitely not in my field but I think you could use Missing Value Codes for this.

Using Consumer Preferences example dataset. First example without Missing Value Codes:

Categorical analysis as follows:

Categorical(
	X(:Age Group),
	Responses(:Job Satisfaction),
	Crosstab Transposed(1),
	Legend(0),
	Test Response Homogeneity(1)
)

Then set Not at all satisfied as missing value code and rerun analysis:

Missing Value Codes can be set from Column Properties:

Or if you don't need those rows at all, you could exclude them totally by first selecting one of the values you want to exclude and choosing Select Matching Cells:

Then from the left side select one of the rows which you have selected and choose Hide and Exclude:

and analysis to show how it affects the results: