I have a macro that uses DDE to write an Excel workbook with several worksheets. The name of the workbook is a concatenation of the path name, a string constant, and a macro variable that contains the product name. I need to update the macro to add an invocation for a new product that has a slash in the name, as in %let product = 'Product This/That'. For that run, the workbook is not created, and the message in the log is ERROR: DDE session not ready. FATAL: Unrecoverable I/O error detected in the execution phase of the DATA step program. Aborted during the EXECUTION phase. I have tried %quote with the variable assignment, and the SYMBOLGEN parameter indicates that the variable is resolving correctly. I've also tried increasing the sleep time. The workbook appears to be correctly populated in my Excel display. The macro works fine for all other invocations in the SAS program, before and after this one. Does anyone have an idea about why it works for all the macro variable values except that one?
... View more