Date: Tue, 7 Dec 2004 10:23:22 -0600
Reply-To: "Dunn, Toby" <Toby.Dunn@TEA.STATE.TX.US>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Dunn, Toby" <Toby.Dunn@TEA.STATE.TX.US>
Subject: Re: ODS CSV
Content-Type: text/plain; charset="us-ascii"
It's the equals sign that excel sees and I don't think can interprete
with + and text tha come after it.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Tuesday, December 07, 2004 10:18 AM
Subject: ODS CSV
I used the *experimental* ODS CSV in version 8.2 Windows NT to output a
SAS data set to Excel and noticed a few odd things after conversion.
There are a couple of Text values in rows 1206 and 1207 that begin with
a plus sign (+). The values are preserved but are displayed as #NAME
after conversion to Excel. Upon clicking the cell I can see the values.
I am unable to get it to display the way it should. I tried widening the
cell size, formatting it to text etc., to no avail. Any solutions?
Is ODS CSV production in version 9? If you have 9 and can test the below
code and write to the list or me that will be great. If someone can
replicate the problem that I have in version 8.2 that will be great too.
data test ;
do junk = "+ H PYLORI" , "+ CLO TEST" ;
ods csv file = "c:\c_data\junk\plus_sign_export.csv" ;
ods noresults ;
proc print noobs data = test ;
ods csv close ;
Unless expressly stated otherwise, this message is confidential and may
be privileged. It is intended for the addressee(s) only. Access to this
E-mail by anyone else is unauthorized. If you are not an addressee, any
disclosure or copying of the contents of this E-mail or any action taken
(or not taken) in reliance on it is unauthorized and may be unlawful. If
you are not an addressee, please inform the sender immediately.