Exporting Data from Report Objects to Microsoft Excel 2007
Issue: An error occurs when data from a report object is exported
using the
Export to: Excel 2007 Workbook (*.xlsx) option
or when there are character codes displayed in the exported Excel
file.
Resolutions:
-
If an error occurs during exporting,
then in the
Export or Save As window, select
either the
Save as: Tab-Separated Values (*.tsv) or
the
Save as: Comma-Separated Values (*.csv) option to create a
data file.
-
If you see
character codes displayed in a file that has been exported to Excel, then re-open the exported
file in Excel, and save it without any changes. The character codes are removed from
the file.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 8, 2019