Example of recoding individual values

An engineer copies a column of numbers to a worksheet, and wants to recode the value -999 to the symbol *, which denotes a missing value.

  1. In the column name cell, type Data.
  2. Copy and paste, or type the following data into the Data column:
    91
    92
    77
    -999
    95
    69
    78
    85
    -999
    88
  3. Choose Data > Recode > To Numeric.
  4. In Recode values in the following columns, enter Data.
  5. From Method, select Recode individual values.
  6. In the Recoded value column, change -999 to *.
  7. Click OK.

Results

The recoded values are in a new column of the worksheet.

C1 C2
Data Recoded Data
91 91
92 92
77 77
-999 *
95 95
69 69
78 78
85 85
-999 *
88 88
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy