SPSS Statistics

SPSS Statistics

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

 View Only
  • 1.  SPSS issues

    Posted Mon October 09, 2023 12:58 PM

    Hello,

    I would appreciate assistance with an SPSS file that I am working on. It is unable to analyze properly.

     I noticed there are fields with dots and I am unable to remove them. (This adding to my missing data in my statistics)

    I would also like advise on removing the inactive cases.  

    Please find attached picture 1 with the dots and picture 2 without the dots for illustration. 

    Thank you.

    Kind regards

    Seun



    ------------------------------
    Oluwaseun Omosehin
    ------------------------------


  • 2.  RE: SPSS issues

    Posted Tue October 10, 2023 05:00 AM
    Edited by Patrick Henry-Lucet Tue October 10, 2023 05:02 AM

    Hi.

    What is the source of your data ?
    Excel ?


    I think the dots are system missing values and my guess is that, due to "invisible" missing values in string variables, SPSS counts blank lines as valid ones.

    You could try something like

    select if not sysmis (BESTID).



    ------------------------------
    Patrick Henry-Lucet
    ------------------------------