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. Go to File > Data Sets > Add to Project > From File, and when prompted select Use original data file structure.
  3. On the Variables and Questions tab, against all the variables you want to delete, click the H button in the Tags column.
  4. Select Tools > Save Data as SPSS/CSV File and save it to somewhere appropriate.

If you want to then use this modified datafile (with the deleted variables) in an existing project, select File > Data Sets > Update and import the modified data file.

See also