As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

Creating an Excel report: A comparison of the different techniques

From sasCommunity
Jump to: navigation, search


Many techniques exist to create an Excel file using SAS®. Each of them offers some unique advantages.

LIBNAME statement is a new and useful option available with SAS 9 but old methods like DDE are still very powerful and offer some unique capabilities. Knowing and understanding the different techniques is essential for SAS programmers to quickly and effectively produce a report that will meet the requirement provided by the customer.

This paper will list and describe the different techniques to generate an Excel file from SAS, and provide recommendations on the appropriate method to use when an Excel output must be created.

Online Materials

View the pdf for .

Contact Info

My SAS community page.

Romain Miralles