I'm not sure, but looking at http://support.sas.com/rnd/base/ods/templateFAQ/Excel1.pdf <quote> There are several methods of generating Excel or spreadsheet files using the Output Delivery System. The first method that we will discuss is using the HTML destination to create the Excel or spreadsheet files. When you specify a procedure or data step within the ODS HTML statement with the .XLS or .CSV extensions, Microsoft Excel is opened in the Results Viewer. Excel is not an ODS destination and the fact that the file is opened in Excel is partially a product of ODS. The Results Viewer attempts to open the file based on the files registered extensions. By default the registered extensions of .XLS and .CSV belong to Excel on the PC. </quote> it appears to me that SAS must be running on MS-Windows to generate a .xls output.
-- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * [email protected] * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] > On Behalf Of Vernooij, CP - SPLXM > Sent: Friday, September 14, 2012 9:21 AM > To: [email protected] > Subject: Re: Creating .xls on z/OS > > You don't have SAS? I believe it can. > > Kees. > > > "Walter Marguccio" <[email protected]> wrote in message > news:<[email protected]>... > > Hello all, > > > > I've been asked if there is the possibility to create Excel tables > (.xls) files on z/OS, > > using a batch job. I've searched the archives, the developerwork > IBM's site, redbooks, > > but found no clue. > > We run the XMITIP tool which is able to create .csv files, but this > seems not enough. > > > > We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, > 1.2.0. > > > > Any thoughts, experiences links, books ? > > > > > > Walter Marguccio > > z/OS Systems Programmer > > BELENUS LOB Informatic GmbH > > Munich - Germany > > > > --------------------------------------------------------------------- > - > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to [email protected] with the message: INFO IBM- > MAIN > > > ******************************************************** > For information, services and offers, please visit our web site: > http://www.klm.com. This e-mail and any attachment may contain > confidential and privileged material intended for the addressee only. > If you are not the addressee, you are notified that no part of the e- > mail or any attachment may be disclosed, copied or distributed, and > that any other action related to this e-mail or attachment is strictly > prohibited, and may be unlawful. If you have received this e-mail by > error, please notify the sender immediately by return e-mail, and > delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or > its employees shall not be liable for the incorrect or incomplete > transmission of this e-mail or any attachments, nor responsible for any > delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > ******************************************************** > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
