| Date: | Mon, 28 Jan 2008 05:31:23 -0800 |
|---|
| Reply-To: | Peter <crawfordsoftware@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Peter <crawfordsoftware@GMAIL.COM> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | Re: how to prevent Excel from inteprate string '9E6' when using |
|---|
|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
On 25 Jan, 16:53, zhangy...@GMAIL.COM (Yu Zhang) wrote:
> sorry, Forget to provide a workable code.
> here it is:
>
> data test;
> input id $;
> cards;
> 3RF
> 05U
> uOG
> 3E8
> ;
> run;
>
> ods html file='c:\test.xls';
> proc print data=test noobs;
> run;
> ods html close;
use ODS tagsets.excelXP
There, you can control the interpretation made by excel on the import
from xml. It provides control that is not available with html.
See examples in the SAS User Forum on ODS at
http://support.sas.com/forums/forum.jspa?forumID=6
PeterC
|
