Page 1 of 1

Display all defined values in frequency table

Posted: Thu Jan 12, 2012 3:44 pm
by carrie_83
Does anyone know how to list all the defined values for a variable in a frequency table, and not just the ones that are actually occurring in the dataset? So, I want to list all the values in a Likert scale (Strongly agree, Agree and so on) even though the frequency will be 0. How do I do that?

Re: Display all defined values in frequency table

Posted: Mon Jan 16, 2012 6:28 am
by Analyst Techy
Hi carrie_83.

I couldn't get the Frequency subcommand to display blank values either.

But I was successful in using CTABLES. Try the following:
1. Analyze>Custom Tables>
2. RHS mouse click your variable of interest change Data measure to Nominal this is so you can see all of the values of the variable.
3. Drag the same variable into the rows of the Table GUI.
4. If you're still getting not getting the unused values within the CTABLES dialog box, make sure you doublecheck the Categories and Totals option and tick the Empty Categories.