Date:         Tue, 29 Jun 1999 10:49:06 -0700
Reply-To:     "William W. Viergever" <wwvierg@IBM.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "William W. Viergever" <wwvierg@IBM.NET>
Subject:      Re: EXCEL and dde statement
Comments: To: Peter Baade <Peter_Baade@HEALTH.QLD.GOV.AU>
In-Reply-To:  <s778edc1.006@health.qld.gov.au>
Content-Type: text/plain; charset="us-ascii"

Use NOTAB on the filename stmnt; otherwise the blacks are perceived as the delimiters by Excel.

You'd see that if you reran your code as is but change the range in the filename stmnt to r1c1:r1c11.

HTH, later.



At 03:56 PM 6/29/99 +1000, Peter Baade wrote:
>In the following (very basic) SAS program using DDE, the only text that is
>"copied" into EXCEL is "comparison". Is there an option in the file or dde
>statement to specify what the delimiter is?  There is for infile, but I
>can't find one for file.
>
>filename outtitle dde 'Excel|[Book1]Sheet1!R1C1';
>
>data _null_;
>        put "Comparison of Queensland Cancer mortality rates using ABS and
>QCR databases";
>        run;
>
>(SAS 6.12 and Windows95).
>
>Thanks,
>
>Peter.

----------------------------------------------------------------------------
William W. Viergever                      Voice  : (916) 483-8398
Viergever & Associates                    Fax    : (916) 486-1488
A SAS Institute Quality Partner (USA)     E-mail : wwvierg@ibm.net
Sacramento, CA 95825

"Age is a question of mind over matter. If you don't mind, it don't matter."
- Satchel Paige -

"Reality is merely an illusion, albeit a very persistent one."
- Albert Einstein -
----------------------------------------------------------------------------