DDE is not available with Enterprise Guide working with a remote SAS server as Excel cannot be started in a remote session without a display to interact with.   Check out @art297's option. You could also consider writing to a plain Excel sheet from where an Excel VBA macro can pick up the values to populate the custom template.   You might also want to check out the ODS Excel and Excel tagset options in combination with PROC REPORT for fancy formatting. Please bear in mind though you will be constructing your spreadsheet from scratch with these options and the learning curve for this is pretty substantial. ... View more