04-18-2016 02:32 PM
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.
04-19-2016 01:54 AM
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.
Need further help from the community? Please ask a new question.