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
Comments: To: "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Content-Type: text/plain; charset="us-ascii"

Venky,

It's the equals sign that excel sees and I don't think can interprete
with + and text tha come after it.

Toby

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Chakravarthy, Venky
Sent: Tuesday, December 07, 2004 10:18 AM
To: SAS-L@LISTSERV.UGA.EDU
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" ;
      output ;
   end ;
run ;

ods csv file = "c:\c_data\junk\plus_sign_export.csv" ;
ods noresults ;
proc print noobs data = test ;
run ;
ods csv close ;

Thanks.

Venky Chakravarthy


LEGAL NOTICE
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.