Date: Thu, 7 Dec 2006 13:26:05 +0100
Reply-To: SAS-L List <firstname.lastname@example.org>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Robert Bardos <bardos2@ANSYS.CH>
Subject: Re: ODS Markup ExcelXP
Content-Type: text/plain; charset="us-ascii"
have a look at the encoding option for ODS MARKUP.
I don't have my examples handy right now but I recall having had
to specify e.g. ODS HTML .... ENCODING='wlatin1' when storing
HTML/XLS in mainframe HFS files so as to be able to "click-open"
them immediately as Excel spreadsheets from a link displayed in a
(wlatin1 being useful for Western European Languages)
The following table from "SAS National Language Support: User's
Guide" might help:
Sorry for not being more precise at the moment.
Ansys AG, Zurich, Switzerland
Keith McWhorter wrote:
> I'm using an example from the paper "SAS Excels!" to
> create output as
> XLS to open in Excel. However, I'm running this on the
> mainframe and
> emailing it to myself. When I open the file it's all
> garbage. I've used
> the email part of the code with PDFs successfully. Not
> sure about all
> the parameters I may need for XLS though.
> Anyone see anything glaringly wrong?
> Environment: z/OS 1.4, SAS 9.1.3 SP4