Help using Base SAS procedures

Update Excel worksheet and bring formats in proc export

Reply
Super Contributor
Posts: 396

Update Excel worksheet and bring formats in proc export

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

SAS Super FREQ
Posts: 8,744

Re: Update Excel worksheet and bring formats in proc export


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

Contributor
Posts: 22

Re: Update Excel worksheet and bring formats in proc export

I think DDE should work for that

Ask a Question
Discussion stats
  • 2 replies
  • 166 views
  • 0 likes
  • 3 in conversation