05-01-2017 03:17 PM
05-02-2017 07:37 AM
Dealing with .xls files in SAS was always done by using a Microsoft-supplied, Windows-only software module. So you can't read or write .xls files directly on a UNIX platform. A mechanism to achieve this was provided by using the PC Files Server on a Windows machine and using the excelcs engine in SAS. You might consider doing that.
With 9.4, a platform-independent access to Open Office format (.xlsx) is implemented in SAS, and therefore you don't need any other tools to read/write such files in a variety of ways (import/export, libname) on any supported platform.
A license for SAS/ACCESS to PC Files is required in any case.
As a stable, solid workaround that does not need any license beyond SAS/Base I recommend to communicate via plain text (csv) files.
05-02-2017 01:38 PM
Thank you Kurt,
FYI,in unix .xls can be generated by ods tagsets.excelxp.
but I don't know how to update a sheet of an existed file with this.
This is an often encountered mistake. tagsets.execlxp does not create a true xls file, it writes a form of XML that Excel understands. Just look at the file with a text editor.
05-02-2017 07:52 AM - edited 05-02-2017 07:56 AM
If possible use the XLSX engine instead of the EXCEL engine.
I've just pasted your Error message into Google and it appears this Error can also get thrown when you've got a 32/64Bit issue.
To compare the capabilities of the different engines:
And here one of Chris Hemedinger's great blogs which also might be helpful to you:
05-02-2017 02:38 PM
You're using software from 2011 that has no updates.
Expecting it to work with software versions that are after isn't a fair expectation.
Upgrade, use DDE or a different software tool.