| Date: | Thu, 22 Jun 2006 09:31:09 -0700 |
|---|
| Reply-To: | Jack Hamilton <kd6ttl@YAHOO.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Jack Hamilton <kd6ttl@YAHOO.COM> |
|---|
| Subject: | Re: ODS to Excel problem |
|---|
|
| In-Reply-To: | <200606221146.k5MBIxP2010784@mailgw.cc.uga.edu> |
|---|
| 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
>
| 
