Date: Thu, 21 Sep 2006 15:15:50 -0400
Reply-To: "Gerstle, John (CDC/CCID/NCHSTP) (CTR)" <yzg9@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Gerstle, John (CDC/CCID/NCHSTP) (CTR)" <yzg9@CDC.GOV>
Subject: Re: Excel XML
Content-Type: text/plain; charset="US-ASCII"
Post to SAS-L an example of the code you're using.
If you're using the ExcelXP tagset, it should be sending character data
to Excel, although Excel may decide to interpret some of the data as
numeric (which is what it sounds like).
John Gerstle, MS
CDC Information Technological Support Contract (CITS)
NCHSTP \DHAP \HICSB \Research, Analysis, and Evaluation Section
Centers for Disease Control and Prevention
"Boss. We've got cats." "Meow"
"All truth passes through three stages:
First, it is ridiculed;
Second, it is violently opposed;
Third, it is accepted as being self-evident."
- Arthur Schopenhauer (1830)
>>On Behalf Of Todd Welsh
>>Sent: Thursday, September 21, 2006 1:32 PM
>>Subject: Excel XML
>>I'm trying to export a sas file to Excel via ODS. I have a variable
>>is 16 bytes in length, defined as a text field but contains all
>>Here is an example of a valid value: 4382121234567009.
>>When I open the xml output, I get this, 4382129E+15. So as you can
>>am pulling in this field as a numeric field rather than text.
>>I've tried to define a style utilizing Proc Template but am unsure
>>specify to as the exact format options and how to use this in my SAS
>>I am assuming the format must match the exact length of output that I
>>or it will fail.
>>Any suggestions will be greatly appreciated.