SPSS Statistics

SPSS Statistics

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


#Analytics
#SPSSStatistics
#Analyticstools
 View Only
  • 1.  missing values -99

    Posted 02/11/22 03:54 AM
    Dear Rick Marcantonio,



    Just one more question please!

     I have to replace missing values with the code -99.
     I  tried it through "select cases" but failed.

    Is there any guidance for this?

    Thank you very much once again!
    Sandy

    #SPSSStatistics


  • 2.  RE: missing values -99

    Posted 02/11/22 11:07 AM
    Hi. I'm not exactly sure what the context is, but here are a couple of things...

    If in your SPSS Data Editor you see "." in some cells (we call those "sysmis" or system-missing values) and you want them to be -99 and defined as missing, try

    RECODE <whatever variables> (SYSMIS=-99). ​
    MISSING VALUES <whatever variables> (-99).

    If you have actual values that you want to change to -99 and then define as missing, then try

    RECODE <whatever variables> (<arg>=-99)​.
    MISSING VALUES <whatever variables> (-99).

    where <arg> can be a variety of things, like:

    1. LO THRU HI
    2. LO THRU <some number>
    3. <some number> THRU HI
    4. <some number> THRU <some other number>
    5. <some list of values, from 1 value to a series of them>
    etc.

    or even certain combinations of these, depending on what the need is.

    Finally, I have also used the SYSMIS function on the IF command:

    IF SYSMIS(<some variable>) <some variable> = -99.​
    MISSING VALUES <some variable> (-99).


    You can find details on IF, RECODE, SYSMIS, and MISSING VALUES in the Command Syntax Reference.



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



  • 3.  RE: missing values -99

    Posted 02/12/22 02:55 AM
    Good morning!

    Your help was really useful once again!

    Thank you very much!
    Sandy


    Στις Παρ 11 Φεβ 2022 στις 6:09 μ.μ., ο/η Rick Marcantonio via IBM Community <Mail@connectedcommunity.org> έγραψε:
    Hi. I'm not exactly sure what the context is, but here are a couple of things... If in your SPSS Data Editor you see "." in some cells (we call...
    IBM Community

    SPSS Statistics

    Post New Message
    Re: missing values -99
    Reply to Group Reply to Sender
    Rick Marcantonio
    Feb 11, 2022 11:07 AM
    Rick Marcantonio
    Hi. I'm not exactly sure what the context is, but here are a couple of things...

    If in your SPSS Data Editor you see "." in some cells (we call those "sysmis" or system-missing values) and you want them to be -99 and defined as missing, try

    RECODE <whatever variables> (SYSMIS=-99). MISSING VALUES <whatever variables> (-99).
    If you have actual values that you want to change to -99 and then define as missing, then try

    RECODE <whatever variables> (<arg>=-99). MISSING VALUES <whatever variables> (-99).
    where <arg> can be a variety of things, like:

    1. LO THRU HI
    2. LO THRU <some number>
    3. <some number> THRU HI
    4. <some number> THRU <some other number>
    5. <some list of values, from 1 value to a series of them>
    etc.

    or even certain combinations of these, depending on what the need is.

    Finally, I have also used the SYSMIS function on the IF command:

    IF SYSMIS(<some variable>) <some variable> = -99. MISSING VALUES <some variable> (-99).


    You can find details on IF, RECODE, SYSMIS, and MISSING VALUES in the Command Syntax Reference.



    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward  
    -------------------------------------------
    Original Message:
    Sent: Fri February 11, 2022 03:53 AM



     
    You are receiving this notification because you followed the 'missing values -99' message thread. If you do not wish to follow this, please click here.

    Update your email preferences to choose the types of email you receive

    Unsubscribe from all participation emails