ONLY FOR ZEEK THE GREEK

© 2015 – A.T. Still University – Last Updated: July 19 2014

1

DHSC9035 Data Collection for Applied Research Project

SPSS Instructions for SPSS Part I – Purchase, Installation, and Dataset

Preparation

Steps to Creating the Codebook (i.e., data dictionary)

1. Complete the Variable View Worksheet (Preventive Care & HbA1c Worksheet.docx)

in preparation for completing the codebook in the SPSS ® data file

(PrevCare_HbA1c.sav)

2. Once the Worksheet is complete, open the SPSS ® data file and click on the “Variable

View” tab to show the variable list. The Variable View is the codebook view in SPSS ® .

3. Now complete the rows in the codebook using the completed Worksheet as a guide.

Steps to Locating and Assigning the Missing Data Code to All Missing Data

1. Click on the “Data View” tab in the SPSS ® data file.

2. Review the data to locate and assign the missing data code (-99) for all missing data.

Missing Data

© 2015 – A.T. Still University – Last Updated: July 19 2014

2

SPSS Instructions for SPSS Part I – Purchase, Installation, and Dataset Preparation DHSC9035 Data Collection for Applied Research Project

3. Now that all the missing data have been assigned the missing data code (i.e., -99), there

should be no blank cells in your data sheet. Then, be certain to add "-.99" (with no quotation

marks) as one of the “Missing” values in your codebook (Variable View) for that variable.

Otherwise, when you analyze your data, SPSS ® will incorrectly treat "-99" as a valid entry. For

example, if you discover a blank cell for the variable “Age”, you would replace the missing

value with “-99” and then add “-99” to the “Missing” column in the “Age” row within the

codebook (Variable View).