Date: Fri, 21 Dec 2001 08:06:55 -0800
Reply-To: Dexter Road <dexter_road@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dexter Road <dexter_road@YAHOO.COM>
Organization: http://groups.google.com/
Subject: Re: LEADING QUOTES IN EXCEL
Content-Type: text/plain; charset=ISO-8859-1
"Dirk Cosijn" <dirk.cosijn@pandora.be> wrote in message news:<%arU7.1654$a33.137@afrodite.telenet-ops.be>...
> Hi all,
>
> When exporting a sas datasets in V8 to excel 2000,
> single quotes are inserted before every
> character variable.
I had this problem while using proc export running 8.2 on Win NT.
I replaced proc export with proc dbload - and no quotes.
Here's my code:
proc dbload dbms=xls
data=work.mydata;
path="C:\my.xls";
putnames Yes;
reset all;
load;
run;
Will that work for you?
Tammie
|