How to export Excel file (.xls or .xlsx) from my SAS data set in 9.3 SAS version?

[ybz12003]

Hi, all:

I'm currently using SAS 9.3 version.   I would like to export my SAS data to Excel format (.xls or .xlsx), not CSV format.  Please help, thanks.

Y

[JediApprentice · Accepted solution]

Use proc export:

proc export 
  data=dataset
  dbms=xlsx
  outfile="C:\temp\myfile.xlsx"
  replace;
run;

[Kurt_Bremser]

You will have a much easier life in the future if you use an open, textual format for the data transfer (as long as you only do that; for reports with formatting ODS TAGSETS.EXCELXP is of course the way to go).

Why do I say that?

MS is prone to make changes in their formats and how Excel treats data from version to version, giving one severe headaches. The import/export from/to CSV has worked all the time (in my experience).

Another reason is that you can debug a CSV file with a simple text editor. Even though XLSX is zipped XML and not binary, manually looking for problems can be a major PITA.

Third reason: CSV can be used to transfer the data to ANY system that is more suited for BI than Excel.

[ybz12003]

I need to upload the Excel file to our internal website, it wouldn't recognized the CSV format, only .xls and .xlsx.