SPSS Statistics

SPSS Statistics

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

 View Only
Expand all | Collapse all

Variable string converted to numeric without losing data

  • 1.  Variable string converted to numeric without losing data

    Posted Thu July 01, 2021 10:31 AM

    I have a variable that is nominal string data, i.e. male and female. I have then added values 1 for male and 2 for female. But then, variable from string to numeric, the nominal data in data view disappears. It just shows up as a blank. In other words, the data requires a manual keying back using a drop-down menu showing male and female. It is okay if there is only a small number of rows but not when there are thousands. Does anyone know how to copy and paste the data back in, please?






    #SPSSStatistics
    #Support
    #SupportMigration


  • 2.  RE: Variable string converted to numeric without losing data

    Posted Thu July 01, 2021 12:07 PM

    o automatically recode variables:

    1. Click Transform > Automatic Recode.
    2. Select the string variable of interest in the left column and move it to the right column.
    3. Enter a new name for the auto-recorded variable in the New Name field, then click Add New Name.
    4. SPSS will assign numeric categories in alphabetical order.






    #SPSSStatistics
    #Support
    #SupportMigration