Date:         Mon, 6 Jun 2011 09:32:34 -0400
Reply-To:     "Bian, Haikuo" <HBian@FLQIO.SDPS.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Bian, Haikuo" <HBian@FLQIO.SDPS.ORG>
Subject:      Re: CSV file problem
Comments: To: =?windows-1255?Q?=E2=E3=E9_=E1=EF_=E0=E1=E9?= <GADI_B@MALAM.COM>
In-Reply-To:  <C11DED818B17214792B97FBA28712BED04FA69C77A@JER-EMAIL1.jer.ad.malam.com>
Content-Type: text/plain; charset="windows-1255"

Gadi,
I am not if I have understood your question accurately. But it seems to me that you can always "proc export" to excel with your "+" on. For example:

data test;
infile cards;
input a $;
cards;
+40
;
run;


proc export data=test
            outfile="c:\temp\test.xls"
                        dbms=excel;
run;


You can easily read CSV file into SAS , then export it to Excel.

HTH,
Haikuo

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of ??? ?? ???
Sent: Monday, June 06, 2011 6:54 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: CSV file problem

Hi,

I am trying to create a CSV file that will be loaded into Excel.
One of the fields can have the value +40.
This is not a number, but a text value. The plus sign must be displayed.
I’ve tried many combinations, but I can’t get Excel to display the plus sign.

Does anyone have an idea how to get Excel to display the plus sign.

The SAS program is running under z/OS and SAS/Base v9.2.

Thanks

Gadi


________________________________
לשימת לבך, בהתאם לנהלי החברה וזכויות החתימה בה, כל הצעה, התחייבות או מצג מטעם החברה, מחייבים מסמך נפרד וחתום על ידי מורשי החתימה של החברה, הנושא את לוגו החברה או שמה המודפס ובצירוף חותמת החברה. בהעדר מסמך כאמור (לרבות מסמך סרוק) המצורף להודעת דואר אלקטרוני זאת, אין לראות באמור בהודעה אלא משום טיוטה לדיון,
ואין להסתמך עליה לביצוע פעולה עסקית או משפטית כלשהי.


Please note that in accordance with Malam's signatory rights, no offer, agreement, concession or representation is binding on the company,
unless accompanied by a duly signed separate document (or a scanned version thereof), affixed with the company's seal.
-----------------------------------------
Email messages cannot be guaranteed to be secure or error-free as
transmitted information can be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The
Centers for Medicare & Medicaid Services therefore does not accept
liability for any error or omissions in the contents of this
message, which arise as a result of email transmission.

CONFIDENTIALITY NOTICE: This communication, including any
attachments, may contain confidential information and is intended
only for the individual or entity to which it is addressed. Any
review, dissemination, or copying of this communication by anyone
other than the intended recipient is strictly prohibited. If you
are not the intended recipient, please contact the sender by reply
email and delete and destroy all copies of the original message.