Import Data

SAS, SPSS, Stata, Excel, and CSV

Colectica can import data from SAS (sas7bdat and sas7bcat), SPSS (.sav), Stata (.dta), Excel, and CSV data files. 1

You can import an SPSS and Stata files using the Import Wizard.

  1. From the Import tab of the ribbon, click the button corresponding to the format you would like to import.

    ../../../_images/import-ribbon-data-buttons.png

  2. The import wizard will open. Click the Choose input files button to select your data file.

    ../../../_images/import-wizard-select-file.png

  3. Click the Next button.

    ../../../_images/import-wizard-data-file-selected.png

  4. Colectica will read your files and show you a summary of the imported contents.

    ../../../_images/import-wizard-summary.png

  5. Click the Finish button.

  6. Colectica will import your data. Depending on the size of your data file, this may take a few minutes.

  7. A metadata package with your imported information will be opened.

    ../../../_images/import-data-resource-package.png

Footnotes

1

SPSS is a product of IBM. Stata is a product of StataCorp. Excel is a product of Microsoft.