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

Exporting and Extracting Data

 

Back to Basic Instructions for Using the SETS Interface

 

Data can be exported or extracted from the SETS 2.0.Template.

Exporting provides:

  • finer control over records and fields.
  • fields to be exported in a nonoverlapping format.
  • records only in a fixed length, carriage return, and line feed delimited format under the ASCII export.
  • various binary formats available under the data base export.

Extracting allows for:

  • a faster way to obtain the records.
  • all fields to be extracted in the original format.
  • records to be fixed length, nondelimited stream of bites. Fields can also be delimited with carriage returns and line feeds. Trailing spaces can be removed or records padded.

 

Exporting

Data from SETS 2.0 can be exported into: (1) ASCII files for use in SAS, SPSS, EPIInfo, and Beyond 2020, as well as (2) specific database and spreadsheet formats, such as dBase, Excel, FoxPro, Jet, Lotus, and in a text format.

  1. Open SETS 2.0 and the data set.
  2. Click on the + to the left of the Data folder. Names of data files drop down. Click on a file name, then from the resulting box, click Export data > Data base OR Export data > ASCII, depending on the format desired.
  3. Several windows are opened. The window on top is labeled with the name of the data file. With this window open, you may limit the data in your exported file to certain fields or the complete data set.
    • You may select individual fields, by double-clicking on the field.
    • You may select several fields by typing in the field names or holding down the Control key while selecting the desired fields.
    • You may also hold down the Shift key, to select a group of fields that are listed together.
    • You may select all of the fields by clicking on Name (located directly above the field labels list).
  4. Click Select. All of the selected field names will appear in the Field list for base file box.
  5. When prompted, click Yes to select a subset of records based on the fields listed in the above box. Follow the procedure for Selecting Records. When prompted, click Yes.

    If exporting to data base or spreadsheet formats:

    • Click the appropriate export format. Click Select.
    • Type the file name with its path in the space indicated. Click Open.
    • A status bar displays the progress of the export. When the file has been exported, you will be offered the option of viewing the exported file. Click Yes to open the files.

    If exporting to an ASCII file:

    • Type the file name with its path in the space indicated. Click Open.
    • Check the destination of the export to make sure the data will be exported to the correct destination.
    • Check the Write codebook box.
    • Click the Source code generation tab and choose the options you wish to have generated.
    • Click Export. A status bar displays the progress of the export.
    • When the export is finished, a window will pop-up, click Yes to open the files.

 

Extracting

When extracting data, you may choose to extract all of the records, a range of the records, or every nth record from the original format.

  1. At the opening menu, click the + sign to the left of the word Data, so the names of data files drop down. 
  2. Click on a file name > Extract data.
  3. Select the destination drive for storing the extracted data.
  4. Name the file and click Open. This will bring up the Extracting original data template. Follow the instructions in order of the destination, code generation, record selection, and record type tabs. 
    • (1) Destination: Verify the destination listed in the Destination window by clicking on the #2 tab.
    • (2) Code generation: Check the desired option boxes and click on tab #3.
    • (3) Record selection: Choose to extract all of the records or a subset of them, as directed in the window. Click on tab #4.
    • (4) Record type: Check the options, as per the instructions in this window. 
  5. Click Extract. When SETS finishes the extraction, you will return to the Opening menu and the extracted fields will be stored, as designated.

 

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