Display all defined values in frequency table

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 16
Joined: Fri Nov 18, 2011 2:05 pm

Display all defined values in frequency table

Postby carrie_83 » Thu Jan 12, 2012 3:44 pm

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?
Analyst Techy
Posts: 22
Joined: Mon Apr 27, 2009 2:19 am
Location: Melbourne, Australia

Re: Display all defined values in frequency table

Postby Analyst Techy » Mon Jan 16, 2012 6:28 am

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.
Analyst Techy

Any solutions I provide on this forum are free of charge, donations go towards the maintenance of the unaffiliated SPSS forum.

Who is online

Users browsing this forum: No registered users and 1 guest