Date: Tue, 7 Dec 2004 11:28:45 -0500
Reply-To: "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Subject: Re: ODS CSV
Content-Type: text/plain; charset="iso-8859-1"
Thanks for testing. Yes, I also guessed that Excel is trying to interpret
this as a function because the first character is a plus sign. The equal
sign is the indicator that it is trying to read it as a function.
Do you know whether CSV is for production use in version 9? Or do you get
this in the log in version 9?
WARNING: CSV is experimental in this release.
From: Dunn, Toby [mailto:Toby.Dunn@tea.state.tx.us]
Sent: Tuesday, December 07, 2004 11:23 AM
To: Chakravarthy, Venky; SAS-L@LISTSERV.UGA.EDU
Subject: RE: ODS CSV
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.