12-13-2013 11:17 AM
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
12-13-2013 03:56 PM
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:
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.