04-18-2016 07:34 AM
04-18-2016 08:16 AM
04-18-2016 08:52 AM
It looks like you want to write those variable names as column headers to the Excel table. In this case the name literals don't make sense. Please try this:
if _n_ = 1 then put 'report month' '09'x 'claim count';
If something doesn't work, please provide more details (log messages, the output you get, ...)
04-18-2016 09:23 AM - edited 04-18-2016 09:28 AM
04-18-2016 09:35 AM
04-18-2016 08:02 AM
Don't use DDE - its old (very), and not supported, plus doesn't work on some setups. Plus you have all the limitations associated with Excel 95. Why do you need to use it? Proc export works ok, then there is tagsets.excelxp, which allows a lot of customisation even if it does create XML rather than a native XML XLSX file. Then there is libname to Excel, then there is CSV, ... in fact there are so many options which are better than DDE.
04-18-2016 08:04 AM
Don't use blanks in variable names. Use the labels for descriptive text, and put those in your output when necessary.
Blanks in identifiers (variable names, file names etc) only cause additional work, make programs less readable and serve no purpose.