Recode and Case-Subset Tabular Data

Review the Tabular Data Recode and Subset Tips before you start work with a study's files.

To recode and subset variables within a tabular data set:

  1. In the Data File page, click the Recode and Case-Subsetting tab.
  2. One the right side of the variable list, use the Show drop-down list and select one of the following options to show variables in predefined quantities: 10, 20, 50, or All.
  3. Scroll down the screen and click the check boxes to select variables from the table of available values. When you select a variable, it is added to the Selected Variables box at the top of the tab.
    To remove a variable from this box, deselect it from the Variable Type list at the bottom of the screen.
    To select all variables, click the check box beside the column name, Variable Type.
  4. Select one variable in the Selected Variables box, and then click Start.
    The existing name and label of the variable appear in the New Variable Name and New Variable Label boxes.
  5. In the New Variable Label field, change the variable name to a unique value that is not used in the data file.
    The new variable label is optional.
  6. In the table below the Variable Name fields, you can check one or more values to drop them from the subset, or enter new values, labels, or ranges (as a condition) as needed. Click the Add Value/Range button to create more entries in the value table.
    Note: Click the ? Info buttons to view tips on how to use the Recode and Subset table. Also, See Tabular Data Recode and Subset Tips for more information about adding values and ranges.
  7. Click the Apply Recodes button.
    Your renamed variables appear at the bottom of the page in the List of Recode Variables.
  8. Select another variable in the Selected Variables box, click the Start button, and repeat the recode action.
    Repeat this process for each variable that you choose to recode.
  9. To remove a recoded variable, scroll to the List of Recode Variables at the bottom of the page and click the Remove link for the recoded variable that you choose to delete from your subset.