Import Data into Excel from SASΒΆ

Note

SAS to Excel import is a feature of Colectica for Excel Professional.

  1. On the Colectica ribbon tab, click the From SAS button.

    ../../../_images/import-sas-button.png

  2. In the Import dialog, click the button to select a SAS data file to import. This file ends with the extension .sas7bdat.

    ../../../_images/choose-sas-data-file.png

  3. If you have a SAS catalog file with value labels, click the button to select the SAS catalog file. This file ends with the extension .sas7bcat.

    ../../../_images/choose-sas-catalog-file.png

  4. Click the Import button.

  5. Your data and related documentation will appear.

    ../../../_images/imported-data.png

Note

SAS can optionally keep deleted rows in a sas7bdat file. Rows that are marked deleted are imported by the Addin.