Prev: Unix for clinical SAS programmers
Next: Tagsets.Excelxp: How to modify the Excel Row Heights?
From: Tiffany on 13 May 2010 10:55
Hello,

I am looking for some good resources for the ods tagsets.excelxp
function. I am having some trouble with formatting primarily, but
haven't found any comprehensive resources for the basics. I see the
tagattr can format columns, but I am not sure where to find a list of
the formats that can be applied as a tagattr? For example, I have
text fields that look like numbers, when I export to excel using this
function they become numbers, losing leading leading zeros etc. Any
suggestions of helpful materials would be greatly appreciated.

thank you,
Tiffany
From: dagger on 13 May 2010 11:30
Tiffany wrote:
> text fields that look like numbers, when I export to excel using this
> function they become numbers, losing leading leading zeros etc.

use this (for example in proc tabulate, proc report) for the fields with leading zeros


your_variable_name
/ style(column)={htmlstyle="mso-number-format:\@"}



From: Lex Jansen on 13 May 2010 12:10
Check this paper:

ODS ExcelXP: Tag Attr Is It! Using and Understanding the TAGATTR=
Style Attribute with the ExcelXP Tagset
(http://support.sas.com/resources/papers/proceedings10/031-2010.pdf)
Eric Gebhart (SAS Global Forum, 2010-04)

Eric Gebhart has written many papers about ODS tagsets:
http://www.lexjansen.com/cgi-bin/xsl_transform.php?x=agh&s=sugi_a&c=sugi#erichart


On May 13, 10:55 am, Tiffany <tiffany.vi...(a)gmail.com> wrote:
> Hello,
>
> I am looking for some good resources for the ods tagsets.excelxp
> function.  I am having some trouble with formatting primarily, but
> haven't found any comprehensive resources for the basics.  I see the
> tagattr can format columns, but I am not sure where to find a list of
> the formats that can be applied as a tagattr?  For example, I have
> text fields that look like numbers, when I export to excel using this
> function they become numbers, losing leading leading zeros etc.  Any
> suggestions of helpful materials would be greatly appreciated.
>
> thank you,
> Tiffany

From: Paige Miller on 13 May 2010 13:21
On May 13, 10:55 am, Tiffany <tiffany.vi...(a)gmail.com> wrote:
> Hello,
>
> I am looking for some good resources for the ods tagsets.excelxp
> function.  I am having some trouble with formatting primarily, but
> haven't found any comprehensive resources for the basics.  I see the
> tagattr can format columns, but I am not sure where to find a list of
> the formats that can be applied as a tagattr?  For example, I have
> text fields that look like numbers, when I export to excel using this
> function they become numbers, losing leading leading zeros etc.  Any
> suggestions of helpful materials would be greatly appreciated.
>
> thank you,
> Tiffany


I have been looking for a "comprehensive resource" as well.

From what I can see, there is no single comprehensive resource to find
what you are looking for. There are many, many papers (some of which
are excellent), and the only way to know if they cover the particular
technique that you are interested in is to read the paper(s).

--
Paige Miller
paige\dot\miller \at\ kodak\dot\com
From: Paige Miller on 13 May 2010 13:40
On May 13, 10:55 am, Tiffany <tiffany.vi...(a)gmail.com> wrote:
> Hello,
>
> I am looking for some good resources for the ods tagsets.excelxp
> function.  I am having some trouble with formatting primarily, but
> haven't found any comprehensive resources for the basics.  I see the
> tagattr can format columns, but I am not sure where to find a list of
> the formats that can be applied as a tagattr?  For example, I have
> text fields that look like numbers, when I export to excel using this
> function they become numbers, losing leading leading zeros etc.  Any
> suggestions of helpful materials would be greatly appreciated.
>
> thank you,
> Tiffany

To answer your specific question, here's a PROC REPORT statement that
creates values in Excel with up to 3 digits before the decimal place,
and one after the decimal place. The 0 indicates that zero must appear
in that position (in other words, trailing zeros must appear and also
there must be one digit to the left of the decimal), and leading zeros
other than the one immediately left of the decimal will not appear
(that's what the # indicates)

define final_percent / display style(column)={tagattr='format:##0.0'};

--
Paige Miller
paige\dot\miller \at\ kodak\dot\com
 | 
Pages: 1
Prev: Unix for clinical SAS programmers
Next: Tagsets.Excelxp: How to modify the Excel Row Heights?