SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only

  • 1.  "missing values" in custom tables is greyed out.

    Posted Thu November 03, 2022 09:37 AM
    Edited by System Admin Fri January 20, 2023 04:31 PM
    I have a multiple response set and "missing values" option is greyed out. However, I have some participants that have missing values. What do I have to do to activate the missing values option?
    Best regards

    #SPSSStatistics


  • 2.  RE: "missing values" in custom tables is greyed out.

    Posted Thu November 03, 2022 09:56 AM
    Hi. I'm going to need a little more detail. Can you tell me which dialog you're looking at?

    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------

    Original Message


  • 3.  RE: "missing values" in custom tables is greyed out.

    Posted Thu November 03, 2022 10:04 AM
    Edited by System Admin Fri January 20, 2023 04:35 PM
    Hi Rick,

    thank you for your answer. I use Analyze > Tables > Custom Tables.  Then I defined a multiple response set, saved the MRS. Then via Analyze > Custom Tables I took the MRs and dragged and dropped it into Row. Then in ctagories and tools, "missing values" is greyed out.



    Original Message


  • 4.  RE: "missing values" in custom tables is greyed out.

    Posted Thu November 03, 2022 10:05 AM
    I'm guessing that you have a multiple dichotomy set and are looking at the Categories and Totals subdialog in Custom Tables.

    With a MD set, only the counted value matters - other values, whether missing or not, would not be counted, so the Missing Values option does not apply.

    --



    Original Message


  • 5.  RE: "missing values" in custom tables is greyed out.

    Posted Thu November 03, 2022 10:16 AM
    Edited by System Admin Fri January 20, 2023 04:49 PM
    Hey Jon,

    thank you! I changed from dichotomies to categories just to try it out and yep, this seemed to be the problem. I think it's kinda odd though because when I simply go by "Analyze > Multiple Responses", SPSS will show valid and missing and "percent of cases" here seem to be the same as "Count Valid N%" via custom tables. So my table is well aware about the valid N but won't display it. 

    But thanks for your help!



    Original Message


  • 6.  RE: "missing values" in custom tables is greyed out.

    Posted Thu November 03, 2022 10:39 AM
    It's the logic of a multiple dichotomy set.  If you change it to a multiple category set, you can see all the values, and if you check the Missing Values box, those counts will also appear in the table, assuming that they are user missing.

    --



    Original Message