Date:         Wed, 29 Apr 2009 13:20:00 -0500
Reply-To:     Mary <mlhoward@AVALON.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Weird format in ODS HTML
Comments: To: CP Jen <plessthanpointohfive@GMAIL.COM>
Content-Type: text/plain; format=flowed; charset="Windows-1252";
              reply-type=original

CP Jen,

I work with vision data like 20/40 and have had luck moving these to Excel
by:

1.  Making sure the variable is a character variable defined with a
character format, such as $20.;
2.   Using Excel tagsets to move it:

ods listing close;
ods tagsets.excelxp file=&filename
style=analysis3
options(absolute_column_width='10,30,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8'
sheet_label=' ');

ods tagsets.excelxp options(sheet_name=&sheetname);
title &titlename;
proc print...
run;
ods tagsets.excelxp close;
ods listing;

-Mary

----- Original Message -----
From: "CP Jen" <plessthanpointohfive@GMAIL.COM>
To: <SAS-L@LISTSERV.UGA.EDU>
Sent: Wednesday, April 29, 2009 12:53 PM
Subject: Weird format in ODS HTML


>I am outputting tables to EXCEL using ODS HTML.  Every now and then one of
> my numbers, which is a fraction, gets re-formatted by EXCEL into a date.
>
> For instance, I have one fraction 12/9459 that gets turned into Dec-59.
> Only in that one cell.  The other cells in the column of fractions are
> fine.
>
> How can I get SAS to output these tables so that these columns are
> formatted
> as text variables?
>
> Thanks,
>
> CP Jen