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

Making Tables

 

Back to Basic Instructions for Using the SETS Interface

 

These instructions will walk you through the process of building a simple table using the SETS 2.0 Template. Experienced users may not need to use this template, and can choose the Advanced option. Additionally, users wishing to make many tables may want to use the QuickTab table generator from the SETS folder.

 

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.

  • To select a subset of records, see Selecting Records. To recode fields, see Recoding Fields.
  • On the menu bar, click Table Assist, which opens the Table Assistance window.

Table Assistance Screen

Complete steps 1-4 below:

  1. Select fields:
    Choose the fields for the variables you wish to use to build the table. SETS 2.0 will tabulate a two-way table. If you are selecting multiple fields, consider creating a series of tables.
    • The order that the fields appear is important, as the first field name will make up the y-axis of your table.
    • You may add and remove field labels by highlighting the field and clicking on the appropriate button, or by double-clicking on the actual field name in the fields and recodes listing.
    • Once the fields have been selected, click on the #2 tab.
  2. Nesting options:
    • Select the counts, percent, or rates box(es), as needed. Also, select or change weights or rates, as appropriate.
    • Click the #3 tab to continue.
  3. Generate statements:
    • If needed, check the Abbreviate box. (See explanation provided on the template).
    • Click the Generate button. The table statements selected will appear in the Table selection box. Check the statements to make sure the fields and nesting options were correctly chosen.
      • The resulting table will produce data according to the specifications chosen in Selecting fields and Nesting options.
      • To generate another table, go back to (1) Select fields and repeat steps (1) through (3). SETS 2.0 will allow you to create 4-6 tables at one time.
    • Click on the #4 tab to continue.
  4. Begin tabulation:
    • Check the Labels box to provide the full name(s) of the variable(s) chosen.
    • Check the Zero's box to include rows where the cells have a zero value. Otherwise, the rows with a zero value will be excluded.
    • Check Exprs to display the formula used for generating rates.
    • Click Begin, when ready to build the table. SETS will begin to generate the table.
    • Once SETS has tabulated the data a screen will pop-up and notify you that the table is done. Click OK. (Note: to stop the program, go to Table - Stop.)

 

Finished tables can be saved or printed in various formats, including Excel. However, you can only save to Excel 4.0, as versions 5.0 and 7.0 do not work in this revision of SETS 2.0.

 

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
  • 1 (800) 232-4636
  • Contact CDC–INFO
USA.gov: The U.S. Government's Official Web PortalDepartment of Health and Human Services
Centers for Disease Control and Prevention   1600 Clifton Rd. Atlanta, GA 30333, 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. #