https://communities.sas.com/t5/ODS-and-Base-Reporting/Unable-to-use-DDE-command/m-p/16429#M3465 seems ffrom the Warning, that you are running SAS on zOS (sometimes referred to as MVS ).<BR /> DDE works <B>only</B> on the Microsoft Windows family of platforms. Fri, 13 Nov 2009 11:44:11 GMT Peter_C 2009-11-13T11:44:11Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Unable-to-use-DDE-command/m-p/16428#M3464 Hi,<BR /> <BR /> I am trying to generate an excel report from a sas dataset. I understand that i need to use DDE option for this. But i get a warning message when i execute this code:<BR /> <BR /> FILENAME EXCEL DDE 'EXCEL|SYSTEM';<BR /> FILENAME EXPORT DDE 'EXCEL|SHEET1!R1C1:R2C6' NOTAB; <BR /> OPTIONS XSYNC; <BR /> /* OPEN THE EXCEL WORKBOOK */ <BR /> DATA _NULL_; <BR /> FILE EXCEL; <BR /> PUT'[OPEN("C:\TEMP\BOOK1.XLS")]'; <BR /> RUN; <BR /> <BR /> WARNING: The device type or access method specified, DDE, is not defined to the SAS system. This value is being ignored for compatibility with previous releases. If you intended for this to be aan MVS device type, please specify it on the UNIT= option.<BR /> <BR /> ERROR: Invalid file, EXCEL|SYSTEM.<BR /> ERROR: Error in the FILENAME statement.<BR /> <BR /> Please help me to resolve this as i am struck with the first step itself.<BR /> <BR /> Thanks,<BR /> Mee Fri, 13 Nov 2009 09:45:01 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Unable-to-use-DDE-command/m-p/16428#M3464 deleted_user 2009-11-13T09:45:01Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Unable-to-use-DDE-command/m-p/16429#M3465 seems ffrom the Warning, that you are running SAS on zOS (sometimes referred to as MVS ).<BR /> DDE works <B>only</B> on the Microsoft Windows family of platforms. Fri, 13 Nov 2009 11:44:11 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Unable-to-use-DDE-command/m-p/16429#M3465 Peter_C 2009-11-13T11:44:11Z