How to Remove Personally Identifiable Information from a Data Set

Introduction

It is generally best practice to not store Personally Identifiable Information, like names and email addresses with survey data, particularly when you need to share the survey data with third parties. For a variety of reasons, this kind of information can end up in your data set and you may have cause to remove it. It is generally best to ask your data provider to remove this information before sending you a file for analysis (or ask them to send you a new file if you discover personal information after you've started working on the data), but you can also take steps to remove it yourself when that option is not available.

This article describes the steps that you can take to remove personal information from a data set that you are working on in Q.

SPSS Files

When using an SPSS file you need to save a new copy of the file and then update your Q project with the new file. The steps are:

1. Select File > New Project.
2. Select File > Data Sets > Add to Project > From File.
3. Choose your data file and click Open.
4. In the Data Import window:
   • Choose Use original data file structure.
   • Untick Advanced > Tidy Up Variable Labels.
   • Unitck Strip HTML from Labels.
5. Click OK.
6. Go to the Variables and Questions tab.
7. For any variable that contains personal information, click the yellow H in the Tags column.
8. Select Tools > Save Data as SPSS/CSV File and click OK.
9. Choose a name and location for your new file and click Save.
10. Select File > Open and open your Q Project.
11. Select File > Data Sets > Update and choose your data set.
12. Select the new version of your file and click OK.

See Also

How to Delete Cases (Observations)

How to Delete Variables From a Project