Date:         Tue, 29 Jun 1999 08:45:28 -0400
Reply-To:     bramley.m@PG.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         bramley.m@PG.COM
Subject:      Re: EXCEL and dde statement
Comments: To: peter_baade@health.qld.gov.au
Content-type: text/plain; charset=us-ascii

Add the NOTAB option to the end of your Filename statement.

HTH,
Michael



From: Peter Baade <peter_baade@health.qld.gov.au> on 06/29/99 01:56 AM

Please respond to Peter Baade <peter_baade@health.qld.gov.au>

To:   sas-l@listserv.uga.edu
cc:    (bcc: Michael Bramley-M/PGI)
Subject:  EXCEL and dde statement




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.