SPSS Statistics

SPSS Statistics

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

 View Only

  • 1.  in analyze>descriptive statistics>cross tabs how do I display the values of missing values?

    Posted Tue October 25, 2022 11:46 AM
    in analyze>descriptive statistics>cross tabs how do I display the values of missing values?  When I run this, I just get the regular values, but I also want to see how many or percent of different missing values of different types for each case.

    ------------------------------
    Jeffrey Broadbent
    ------------------------------

    #SPSSStatistics


  • 2.  RE: in analyze>descriptive statistics>cross tabs how do I display the values of missing values?

    Posted Tue October 25, 2022 11:59 AM
    Hi. Maybe something like this:

    data list free /x y (2F1).
begin data.
1	2
2	2
3	2
1	3
2	3
1	2
2	3
3	4
3	4
2	3
1	4
2	5
3	2
2	1
1	1
end data.

CROSSTABS VARIABLES=x y (1,4)
 /TABLES=x BY y
 /MISSING=REPORT
 /WRITE=NONE.​


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

    Original Message


  • 3.  RE: in analyze>descriptive statistics>cross tabs how do I display the values of missing values?

    Posted Tue October 25, 2022 12:03 PM
    This probably only works for user missing, not sysmis, but I haven't checked that.
    --



    Original Message


  • 4.  RE: in analyze>descriptive statistics>cross tabs how do I display the values of missing values?

    Posted Tue October 25, 2022 12:09 PM
    No, it won't.

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

    Original Message


  • 5.  RE: in analyze>descriptive statistics>cross tabs how do I display the values of missing values?

    Posted Tue October 25, 2022 12:08 PM
    Ugh.

    Sorry, I forgot to put missing values in there.

    MISSING VALUES x (1) y (3).
    CROSSTABS VARIABLES=x y (1,4)
    /TABLES=x BY y
    /MISSING=REPORT
    /WRITE=NONE.

    I don't think that's going to work for system-missing values; you'd have to recode SYSMIS to some out-of-range value and define them as missing values.

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

    Original Message


  • 6.  RE: in analyze>descriptive statistics>cross tabs how do I display the values of missing values?

    Posted Tue October 25, 2022 12:26 PM
    Hi Rick, Thanks much for your response.  I'm not skilled enough to know how to use your suggested command line.  I am using a big dataset with about 20,000 cases (survey responses from different countries).  Sorry to ask for elementary guidance, but how do I modify your suggested command line and where do I enter it in SPSS?  thanks much. Jeff
    Jeffrey Broadbent
    Professor Emeritus, 
    Department of Sociology
    Fellow, Institute on the Environment
    University of Minnesota



    Original Message


  • 7.  RE: in analyze>descriptive statistics>cross tabs how do I display the values of missing values?

    Posted Tue October 25, 2022 01:15 PM
    Here is briefly annotated example to use as guidance.

    ----

    subtitle "Create data with missing values for example".
    data list free /w x y z (4F1).
    begin data.
    1 1 0 .
    2 1 1 3
    3 2 0 2
    4 2 1 1
    1 3 0 2
    2 3 1 1
    3 4 0 3
    4 5 1 2
    end data.
    recode z (SYSMIS=4).
    missing values x (5) z (4) w (3).

    ** Notice that I had a system-missing value for z, so I had to
    ** recode it to an "out-of-range" value (4), then set that to
    ** missing using the MISSING VALUES command.

    subtitle "Make sure I know the ranges of each variable I want in CROSSTABS".
    DESCRIPTIVES VARIABLES=w x y z /STATISTICS MIN MAX.

    ** Now I know the ranges of all the variables I want to use in CROSSTABS.
    ** That will be used in the VARIABLES subcmd of CROSSTABS.

    subtitle "Run CROSSTABS".

    * In VARIABLES, you add the range of each variable (or a series of variables that
    * share the same range).
    * In TABLES, you set up whatever crosstabulations you want.
    * MISSING=REPORT gives you the counts of missing data in the table.

    CROSSTABS VARIABLES x (1,5) y (0,1) w z (1,4)
     /TABLES=x by z /y by z /x by y /w by x y z
     /MISSING=REPORT.

    ----

    I hope that helps.

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

    Original Message