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 | hlthe |
| 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 | hlthes2006.sav |
| Questionnaire | hlthes2006questionnaire.txt |
| Codebook | hlthes2006codebook.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.
Questionnaires
| Level | Variable |
|---|---|
| State | STCMSID |
| District | DISTCMSID |
| School | SCHCMSID |
| Classroom | CLCMSID |
The questionnaires are available in either PDF or txt formats.
Codebooks
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:
- Division of Adolescent and School Health
4770 Buford Hwy, NE
MS K29
Atlanta, GA 30341 - 800-CDC-INFO
(800-232-4636)
TTY: (888) 232-6348
Hours of Operation
8am-8pm
ET/Monday-Friday
Closed Holidays - cdcinfo@cdc.gov
