Date:         Thu, 7 Dec 2006 13:26:05 +0100
Reply-To:     SAS-L List <sas-l@listserv.uga.edu>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Robert Bardos <bardos2@ANSYS.CH>
Subject:      Re: ODS Markup ExcelXP
Comments: To: "McWhorter, Keith" <Kmcwhort@GTA.GA.GOV>
In-Reply-To:  <6114A3F7BB98C645B9D12B42E650A63208D5D56D@GTA-ATL-EXC01.gta.ad.ga.gov>
Content-Type: text/plain; charset="us-ascii"

Keith,

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
HTML page.

(wlatin1 being useful for Western European Languages)

The following table from "SAS National Language Support: User's
Guide" might help:
http://support.sas.com/onlinedoc/913/getDoc/en/nlsref.hlp/a0026602
06.htm
or http://tinyurl.com/yanjy2

Sorry for not being more precise at the moment.


Robert Bardos
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?
> Thanks!
>
> Environment:  z/OS 1.4, SAS 9.1.3 SP4