Update Excel worksheet and bring formats in proc export

[podarum]

Hi,  is there a way I can just update an Excel (2010) worksheet (while leaving the other worksheets untouched), and also bring over the formats form SAS to Excel.. for example percentages, numbers, dollars.. etc.  Thanks

[Cynthia_sas]

Hi, generally when you use PROC EXPORT or the LIBNAME engine, your SAS formats are not respected by Excel when it opens the file. That's because Excel has defaults that it uses. See this user group paper for some examples of exported data versus using ODS techniques:

http://support.sas.com/resources/papers/proceedings13/316-2013.pdf

If you use the Output Delivery System, you can work around some of the Excel defaults, however, ODS cannot write to an existing workbook or add a sheet to an existing workbook.

cynthia

[ping]

I think DDE should work for that