Unable to use DDE command

[deleted_user]

Hi,

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:

FILENAME EXCEL DDE 'EXCEL|SYSTEM';
FILENAME EXPORT DDE 'EXCEL|SHEET1!R1C1:R2C6' NOTAB;
OPTIONS XSYNC;
/* OPEN THE EXCEL WORKBOOK */
DATA _NULL_;
FILE EXCEL;
PUT'[OPEN("C:\TEMP\BOOK1.XLS")]';
RUN;

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.

ERROR: Invalid file, EXCEL|SYSTEM.
ERROR: Error in the FILENAME statement.

Please help me to resolve this as i am struck with the first step itself.

Thanks,
Mee

[Peter_C · Accepted solution]

seems ffrom the Warning, that you are running SAS on zOS (sometimes referred to as MVS ).
DDE works only on the Microsoft Windows family of platforms.