The SAS Output Delivery System and reporting techniques

Unable to use DDE command

Reply
N/A
Posts: 0

Unable to use DDE command

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
Valued Guide
Posts: 2,177

Re: Unable to use DDE command

Posted in reply to deleted_user
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.
Ask a Question
Discussion stats
  • 1 reply
  • 822 views
  • 0 likes
  • 2 in conversation