Skip directly to local search Skip directly to A to Z list Skip directly to navigation Skip directly to site content Skip directly to page options
CDC Home

SHPPS 2006 Data Files and Documentation Data User's Guide

SHPPS 2006 data include 23 questionnaires, 27 data files, and 27 codebooks. Files are grouped by administration level (state, district, school, and classroom) and by component.

File Names

File names include three parts. The first part identifies the component, the second part identifies the level, and the third part indicates the survey year.

Component Part
Health education hlthed
Physical education and activity physed
Health services hlthser
Mental health and social services mental
Healthy and safe school environment env
Nutrition services foodser
Faculty and staff health promotion faculty
Status status
Level Part
State s
District d
School l
Classroom c

The questionnaire and codebook files use the same naming convention but add the words "questionnaire" or "codebook" to the file name.

For example, the files for health education at the state level would be:

Health education file Name
SPSS data hltheds2006.sav
Questionnaire hltheds2006questionnaire.txt
Codebook hltheds2006codebook.rtf

Data Files

The data files are available in:

  • SAS
  • SPSS
  • Microsoft Access formats

The sections below provide information specific to each data format.

SAS Format:

SAS version 7.0 data files. The variables have been formatted and missing values have been defined. A format library has been provided and must be referenced by SAS programs for the datasets to be used. The library is named formats.sas7bcat. For detailed information on using SAS datasets and format libraries, please refer to the documentation provided with your SAS system.

SPSS Format:

SPSS version 9.0 data files. The data have been formatted and missing values have been defined. For detailed information on using SPSS datasets, please refer to the documentation provided with your SPSS system.

Access Format:

Access data files. In some cases, there are too many variables for one Access table. In these instances, the dataset is split into multiple tables. For detailed information on using Access databases, please refer to the documentation provided with your Access software.

Status Files

The status files contain additional information for the component-specific datasets. There are four status files, one for each level (state, district, school, and classroom). The status files contain

  • Enrollment information for district, school, and classroom data
  • School type for school and classroom data
  • Region of country for district, school, and classroom data
  • Overall weight variable to be used when the datasets are combined across components

Each status file contains a specific variable that needs to be used to link its associated dataset. For example, to link the state status file with another SHPPS state-level dataset, the variable STCMSID is used.


Level Variable
Classroom CLCMSID

The questionnaires are available in either PDF or txt formats.


The codebooks are available in rich text format (rtf). The codebooks contain the

  • Variable names*
  • Variable labels
  • Values
  • Formatted values
  • Unweighted counts

*The first three letters of the variable name identifies the questionnaire. The number at the end of the variable names represents the question number from the associated questionnaire.


Contact Us:
  • Adolescent and School Health
    Centers for Disease Control and Prevention
    4770 Buford Hwy, NE
    MS K-29
    Atlanta, GA 30341
  • 800-CDC-INFO
    TTY: (888) 232-6348
  • Contact CDC-INFO The U.S. Government's Official Web PortalDepartment of Health and Human Services
Centers for Disease Control and Prevention   1600 Clifton Road Atlanta, GA 30329-4027, USA
800-CDC-INFO (800-232-4636) TTY: (888) 232-6348 - Contact CDC–INFO
A-Z Index
  1. A
  2. B
  3. C
  4. D
  5. E
  6. F
  7. G
  8. H
  9. I
  10. J
  11. K
  12. L
  13. M
  14. N
  15. O
  16. P
  17. Q
  18. R
  19. S
  20. T
  21. U
  22. V
  23. W
  24. X
  25. Y
  26. Z
  27. #