07-28-2011 03:56 PM
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?
07-29-2011 10:53 AM
No, it doesn't. Thanks for the idea! I thought only a backslash would be a problem, but that showed me the forward slash doesn't work either.
07-29-2011 10:55 AM
You are right! I thought it would only balk at the backslash. Thanks to you and to twocanbazza! I've been trying to get past this problem for a long time.
Need further help from the community? Please ask a new question.