SPSS Statistics

SPSS Statistics

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

 View Only
  • 1.  Computing new variable results in empty values

    Posted Mon March 13, 2023 07:17 AM

    I have entered this syntax:
    COMPUTE MSPSS_all=MEAN(MSPSSm1, MSPSSm3, MSPSSm4, MSPSSm5, MSPSSm7, MSPSSm10, MSPSSm11, MSPSSm12, MSPSSm13, MSPSSm14, MSPSSm16, MSPSSm18).
        execute.

    These are ordinal variables Likert scale 1-7 and set as such.

    When I run this command, it does result in a new variable named MSPSS-all but without values, all are empty? How to solve this?




    ------------------------------
    Renee Damstra
    ------------------------------


  • 2.  RE: Computing new variable results in empty values

    Posted Mon March 13, 2023 07:29 AM
    Does your syntax yield an error message?
    Are the MSPSS_all cells empty or do they contain a period each?

    You might want to check the missing values declarations of the variables you are averaging.

    Also, running this may help finding missing values:

    FREQUENCIES
      VARIABLES = MSPSSm1 MSPSSm3 MSPSSm4 MSPSSm5 MSPSSm7 MSPSSm10 MSPSSm11 MSPSSm12 MSPSSm13 MSPSSm14 MSPSSm16 MSPSSm18.





  • 3.  RE: Computing new variable results in empty values

    Posted Mon March 13, 2023 10:37 AM

    Problem has been solved, thanks!



    ------------------------------
    Renee Damstra
    ------------------------------



  • 4.  RE: Computing new variable results in empty values

    Posted Mon March 13, 2023 08:29 AM

    I'd also check to make sure there are not value labels on the 1-7.



    ------------------------------
    Art Jack
    ------------------------------