Export data from SAS into Microsoft Excel

There are a number of ways to export data from SAS into Microsoft Excel. However, very few allow for exporting into custom-formatted spreadsheets such as those demanded for specific reports, in which explicit attributes such as font sizes and column widths are required. Traditionally, Dynamic Data Exchange (DDE) was the only way to do this. Now there are newer methods for this which are considered superior…

Various methods are —

1. Proc Export / SAS Export wizard
2. Dynamic Data Exchange (DDE)
3. ODS CSV / HTML xls file route…create a .csv file and open with Excel
4. SAS to Excel via XML
5. Libname with xls
6. Using Display manager command Dexport to create a csv file

1. Proc Export / SAS Export wizard

2. Dynamic Data Exchange (DDE)

Export SAS datasets to Excel with DDE – 

3. ODS CSV / HTML xls file route…create a .csv file and open with Excel

4. SAS to Excel via XML

Export SAS datasets to Excel via XML –

5. Libname with xls

Export SAS datasets to Excel -

6. Using Display manager command Dexport to create a csv file….The Display manaager (DM Dexport) command invokes the External File Interface of SAS…

dm "dexport sashelp.class 'C:\class.csv' ";

dm "dexport sashelp.class 'C:\class.xls' ";

Interesting References….

Excellent Ways of Exporting SAS Data to Excel