Can ODS create Excel output?
in [SAS]
|
From: BruceBrad on 3 Mar 2010 18:35 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?
From: Arthur Tabachneck on 3 Mar 2010 18:41 Bruce, 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. Art ------------ On Mar 3, 6:35 pm, BruceBrad <b.bradb...(a)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?
From: Alan Churchill on 3 Mar 2010 21:30 No. If proper means binary. http://support.sas.com/kb/37/040.html I will be doing a talk on an alternate methodology at SGF that does produce binary files in 2003 and 2007 format. Alan Alan Churchill Savian www.savian.net Office: (719) 687-5954 Cell: (719) 310-4870 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of BruceBrad Sent: Wednesday, March 03, 2010 4:35 PM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Can ODS create Excel output? 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?
|
Pages: 1 Prev: check for variable existence, if not there put variable in. Next: importing from Excel |