Getting data in Excel format (or dBase, RATS, SAS, SPSS, etc.)
- From an SSDC "files" menu, click on the "Subset/Convert" button
for the file you'd like to get.
- Fill out the Subset/Convert form specifying the varilables and
records you'd like to get.
- In the "Output Options" portion of the form, choose the format
you'd like from the pick list.
- Be sure to specify the maximum number of records to get.
(Specify a small number if you would like to test the subsetting and
formatting; specify "all" if you want to get every record that
matches your needs.)
- Click the "get the data" button.
Important: You must specify one or more
variables in the
"Output Variables/Columns" portion of the form. Some studies
have pick lists in this part of the form and others have a text
box where you must type in column ranges. For those that have
pick lists, simply click on the variables you'd like. For
those that have text boxes, consult the codebook or other
available documentation to determine the column locations of
the variables you want and enter those locations one column
location or range per variable in the text box.
For additional information and examples of using the
Subset/Convert form for creating subsets can converting
data into specific software formats, see the SSDC help page:
Using the Subset/Convert Form
