| Date: | Thu, 22 Jun 2006 09:34:52 -0700 |
|---|
| Reply-To: | jfh@stanfordalumni.org |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Jack Hamilton <jfh@STANFORDALUMNI.ORG> |
|---|
| Subject: | Re: ODS to Excel problem |
|---|
| Content-Type: | text/plain; charset=iso-8859-1 |
|---|
Use the ExcelXP tagset instead of HTML, and specify an Excel format in
the tagattr (probably '000000000000').
There was recently a discussion of a related problem in the SAS
Community Forum:
<http://support.sas.com/forums/thread.jspa?forumID=6&threadID=462&tstart=0>
> --- Jamie Henderson <jamie.henderson@LLOYDSTSB.CO.UK> wrote:
>
> > I use ODS HTML to output a dataset to Excel. The dataset has
> fields
> > that
> > are formated with z12.
> >
> > When these are output to Excel, the formatting is lost and all
> padded
> > zero's disapear.
> >
> > Is there anyway I can around this?
> >
> > Thanks
> >
>
>
---
Jack Hamilton
Sacramento, California
| 
