Date:         Fri, 4 Jan 2008 07:37:54 -0800
Reply-To:     Peter <crawfordsoftware@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter <crawfordsoftware@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Export SAS File to Excel by DDE
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On 4 Jan, 15:28, nabo...@mh.state.oh.us wrote:
> Could someone help me, I was trying to export a SAS data set into
> excel by using DDE.  I had two problems: The export termanented when
> it incounter blank cell (i.e., returns); Another problem occurred when
> spaces appeared in my variable (i.e., Name), it would created multiple
> cell in excel.
> My SAS data set look like the following:
> city             state  returns  type      name
> Toledo         Ohio      Y        F     FName Lname
> Cleveland     Ohio                T     Smithson
> U Sandusky Ohio      Y        T     Fname Lname2
> North Canton Ohio     Y        T     Fname Lname3
> Below is my sas code:
> filename xfile DDE "excel|data!r2c1:r2000c5" ;
> DATA _null_;
>   file xfile;
> set Filefnl;
> put
> city state returns type name;
> RUN;
> Thanks

A solution follows, but please explain why you are using DDE.

solution:

extend the file statement from
>   file xfile;
to
>   file xfile dsd dlm='09'x lrecl=1000 ;
You may also nee to add to the filename statement, the option  NOTAB