There are several ways to export data from SAS® into Microsoft® Excel® but very few allow for exporting into customformatted spreadsheets such as those demanded for specific reports. Traditionally, Dynamic Data Exchange (DDE) was the only way to do this. Now there are newer methods for this which are considered superior, and DDE is thought to be obsolete. This paper argues that DDE is actually far from obsolete and outperforms the newer methods in some cases that often arise in practice. Furthermore, this paper offers an accessible, flexible and modifiable macro which exports data from SAS into custom-formatted Excel using DDE. The macro extends the functionality of a previously published macro and addresses some general criticisms of DDE. Using it requires no DDE programming knowledge and thus brings the power of DDE to any PC SAS user. This macro works on all versions of PC Base SAS, Windows R and Excel.
conference:
Paper Type:
Paper
