Data Subset and Recode Tips

Use the following guidelines when working with data files:

  • Subsetting:
    • If the variable you chose for subsetting has information about its value-labels, you can prefill the table with these data for convenience.
    • To exclude a value in the last column of the table, click the check box in the same row.
    • To include a particular value or range, enter it in the last column whose header shows the name of the variable for subsetting.
  • Recoding:
    • You must fill at least the first (new value) and last (condition) columns of the table; the second column is optional and for a new value label.
    • If the old variable you chose for recoding has information about its value-labels, you can prefill the table with these data for convenience, and then modify these prefilled data.
    • To exclude a value from your recoding scheme, click the check box in the same row.
  • Entering a value or range as a condition for subsetting or recoding:
    • Suppose the variable you chose for recoding is x.
      If your condition is x==3, enter 3.
      If your condition is x < -3, enter (--3.
      If your condition is x > -3, enter -3-).
      If your condition is -3 < x < 3, enter (-3, 3).
    • Use square brackets ([]) for closed ranges.
    • You can enter nonoverlapping values and ranges separated by a comma, such as 0,[7-9].