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

Data Access

Recoding Fields


Back to Basic Instructions for Using the SETS Interface


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
    • Double-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.
    • Double-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.
    • If you do not see the recode listed click Cancel, and go to Recodes > Create.
  8. Click Yes. Go to Recodes > Check Syntax. 


Back to Basic Instructions for Using the SETS Interface




Statistical Export and Tabulation System

Contact Us:
  • National Center for Health Statistics
    3311 Toledo Rd
    Room 5419
    Hyattsville, MD 20782-2064
  • 1 (800) 232-4636
    TTY: 1 (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. #