How to Delete Variables

From Q
Jump to: navigation, search

There are a number of ways to remove variables in Q, and the method to use depends on your needs.


Hiding variables from menus

If you only want to prevent variables or questions from showing in your menus in Q (for example if there are a lot of junk variables stored in the data which you don't need for your analysis) you can do so by marking the variables as hidden by clicking the H.png in the Tags column in the Variables and Questions tab. These variables can be returned again by toggling the H.png tag.

Deleting constructed variables

Variables which have been created in Q as copies of other variables, or as formulas or filters, can be deleted by right-clicking them in the Variables and Questions tab and selecting Delete Copied or Constructed Variables. Note that if other variables depend on the variables that you want to delete then you will need to delete those other variables first.

Delete variables from the raw data

In some cases it is necessary to remove variables from the raw data entirely, for example if email addresses or other identifying information have been included in the data set. In this case a new copy of the data file must be created which does not contain these variables.

You can do this in Q by:

  1. Opening a new version of Q.
  2. Importing the data file, selecting No to any questions.
  3. Hiding any variables that you don't want to keep in the data (see above).
  4. Select Tools > Save Data as SPSS/CSV File and save it to somewhere appropriate.
  5. Select File > Data Sets > Update an import the modified data file.

See also

Personal tools