Peter, try: FILENAME outtitle DDE "Excel|[Book1]Sheet1!R1C1" NOTAB ; I am sure that you will also need a FILE statement in your DATA step: FILE outtitle ;

Hope this helps, Ed

Edward Heaton, Sr. Systems Analyst, Westat (An Employee-Owned Research Corporation), 1550 Research Boulevard, Room 2018, Rockville, MD 20850-3159 voice: (301) 610-4818 fax: (301) 294-3992 mailto:heatone@westat.com http://www.westat.com

____________________Reply Separator____________________ Subject: EXCEL and dde statement Author: Peter Baade <Peter_Baade@HEALTH.QLD.GOV.AU> Date: 6/29/1999 3:56 PM

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.