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;
/* OPEN THE EXCEL WORKBOOK */
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.