topic Update Excel worksheet and bring formats in proc export in SAS Procedures

Update Excel worksheet and bring formats in proc export

podarum — Fri, 13 Dec 2013 16:17:16 GMT

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

Re: Update Excel worksheet and bring formats in proc export

Cynthia_sas — Fri, 13 Dec 2013 20:56:21 GMT

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

Re: Update Excel worksheet and bring formats in proc export

ping — Fri, 13 Dec 2013 21:20:15 GMT

I think DDE should work for that