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: a. Click the appropriate export format. Click Select.
b. Type the file name with its path in the space indicated. Click Open. c. 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: a. Type the file name with its path in the space indicated. Click Open. b. Check the destination of the export to make sure the data will be exported to
the correct destination. c. Check the Write codebook box. d. Click the Source code generation tab and choose the options you wish to
have generated. e. Click Export. A status bar displays the progress of the export.
f. 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.
finer control over records and fields.
