Centers for Disease Control and Prevention


About N C H S graphic and link
InformaciĆ³n en EspaƱol
Fastats A-Z provides health statistics and links to additional sources of information
N C H S help graphic and link
Coming Events graphic and link
Surveys and Data Collection Systems graphic and link
National Health and Nutrition Examination Survey graphic and link
National Health Care Survey graphic and link
National Health Interview Survey graphic and link
National Immunization Survey graphic and link
Longitudinal Studies of Aging (LSOAs)
National Survey of Family Growth graphic and link
State and Local Area Integrated Telephone Survey graphic and link
National Vital Statistics System graphic and link
Initiatives graphic and link
Aging Activities graphic and link
Disease Classification graphic and link
Healthy People graphic and link
Injury graphic and link
Research and Development graphic and link
Research Data Center
NCHS Press Room
News Releases graphic and link
Publications and Information Products graphic and link
Statistical Export and Tabulation System
Listserv graphic and link
Graphic and link to FEDSTATS and other sites
Download graphic
Adobe Acrobat Reader graphic and link
PowerPoint Viewer 2003 graphic and link
National Center for Health Statistics 3311 Toledo Road Hyattsville, Maryland 20782
Toll Free Data Inquiries 1-800-232-4636

CDC Home Search Health Topics A-Z
nchshd.jpg (16250 bytes)

 

Recoding Fields

Recoding is used to create new groupings of fields not available in the data file. For instance, one may want to recode age into two groups: under 50 years of age and 50 years and older. If recoding is necessary, it must be completed before making a table.

1. At the opening menu, click the + sign to the left of the data folder. Names of data files drop down. Click on a file name>Tabulate data. This command will provide you with an empty spreadsheet to build a table.
2. Click Recodes
>Create.
3. Change the drive from the CD-ROM drive to your appropriate drive for storing data. Name the recode file and click Open
4. Click Recodes
>Assist.Recode Assistance Screen image
 

bullet graphicDouble-click on the Based on the field box and double-click on the appropriate field. Type in the name for the recode in the New recode name box.

bullet graphicDouble-click on the Code(s) box and select the appropriate code value(s). Click Select to bring up the Recode assistance template. When finished coding, click Accept.

5. The code will appear. To accept it, click Recode>Attach
6. Click File
>Close.
7. Check to see that the recode appears in the field list by clicking Table
>Assist, which opens the Table Assistance window. Scroll down the fields and recodes list and find the recode listed alphabetically.

bullet graphicIf you do not see the recode listed click Cancel, and go to Recodes>Create.

8. Click Yes. Go to Recodes>Check Syntax

 

This page last reviewed January 11, 2007

H H S Health and Human Services logo and link
U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES
Centers for Disease Control and Prevention
National Center for Health Statistics
Hyattsville, MD
20782

1-800-232-4636