Take a look at: support.sas.com/rnd/papers/sgf07/sgf2007-excel.pdf
If that doesn't suffice, do a google search for vince delgobbo
(actually, once you type vince delgo his name will likely appear). He
is a SAS employee who is the official guru in this area.
On Mar 3, 6:35 pm, BruceBrad <b.bradb...@unsw.edu.au> wrote:
> I've been using code like
> ODS MSOFFICE2K file="...xls";
> to produce output to read into Excel. However, this produces html
> output. Excel can read this, but it leads to all sorts of problems
> when linking (I get lots of 'cannot update links' messages in Excel).
> Can ODS produce proper Excel files?