Use PROC EXPORT to Write SAS Data to External Files and Excel Workbooks - Exchanging Data Between SAS and Microsoft Excel - page 29

2.7 Conclusion
The examples in this chapter covered a wide range of conditions, from simple text files that Excel can read
to complex examples that span multiple computers. I have not covered all options and all conditions when
you would need to write data using PROC EXPORT. Below is a simple list of the examples by title for a
quick review.

SAS Code to Export Data to an Excel4 or Excel5 Format File

●

PROC EXPORT using the DBMS=DLM option

●

PROC EXPORT using the DBMS=EXCEL option

●

PROC EXPORT Using the DBMS=EXCELCS Option

●

SAS Code to Export Data to an Excel File with No Column Headers

●

SAS Code to Export Data to a Network Windows Computer

●