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