| Date: | Mon, 13 Dec 2004 16:05:02 -0800 |
|---|
| Reply-To: | "Choate, Paul@DDS" <pchoate@DDS.CA.GOV> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Choate, Paul@DDS" <pchoate@DDS.CA.GOV> |
|---|
| Subject: | Re: SAS to Excel |
|---|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
Jules -
Haven't followed this thread, but if you use ODS HTML and define the
extension as xls, the columns won't have leading quotes.
Paul Choate
DDS Data Extraction
(916) 654-2160
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Datametric
Sent: Sunday, December 12, 2004 12:39 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: RE : SAS to Excel
Hello,
The only way I found to delete the quote was to insert SAS data into excel
via DDE link.
Stéphane.
-----Message d'origine-----
De : SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] De la part de Jules
Bosch
Envoyé : jeudi 27 février 2003 15:02
À : SAS-L@LISTSERV.UGA.EDU
Objet : SAS to Excel
I hope we have some "listeners" this weekend. I have successfully moved a
SAS data set to Excel. The table prints fine but when opened/viewed in
Excel it displays a character (single quote?) at the start of each cell.
What is this character and can it be removed?
TIA,
Jules Bosch
www.BoschSystems.com <http://www.jbcda.com/>
| 
