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

Selecting Records


Back to Basic Instructions for Using the SETS Interface


Selecting records allows you to select a subset of records for tabulating or exporting data. If subsetting 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. Select Records>Select.
  3. Click Assist. 
  4. To select from the field list, type in the field name or left-click twice to display the list and select the appropriate field names.
  5. To select from the code list, type in the code value or left-click twice. For instance, if you want to select a subset of women, double-click on the sex field under the field list and the code for female under the code list.

    selecting records screen image

    You may select from the following operators:

    • =  equal to
    • != not equal to
    • >  greater than
    • <  less than
    • >=greater than or equal to
    • <=less than or equal to
    • : in ("in" operators are used to collect records in or not in an interval)
    • !: not in

  6. If you have more than one criteria for the subset, make sure to chose the appropriate connector. 
  7. For a list of the total records found matching the criteria selected, click Refresh.
  8. Click Accept. 
  9. Click Select to collect the records of the subset. (Once records have been selected, you may change your selection by choosing Records> Clear. To select new records, you must repeat the records selection process.)

    • The system will not retain a selected subset. Changing to a different option (such as from Tabulate to Export) will clear the selected subset.
    • To retain the subset for further use, save the expression to the hard drive before selecting the records. The subset expression can be loaded at a later time for use with another option.


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. #