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.
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.
SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.
Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.