topic Re: EXCEL dde output containing “CR carriage return or line feed or line break” in SAS Programming

EXCEL dde output containing “CR carriage return or line feed or line break”

t_ar_taat — Mon, 07 Nov 2016 15:37:44 GMT

When dde "output" from sas to EXCEL, looking for a method of outputting data to be a new line in the EXCEL file.

For example, when I put "ABC" (actually A??B??C) to excel, and open the EXCEL , I want to see it as

"??" is a special code? "'0A'x"?

In the Internet,there is a information about How to "read" the EXCEL which including the new line code can be found , but there was no way of "output" or "export". please let me you know with your sample code?

Sincerely,t_ar_taat

Re: EXCEL dde output containing “CR carriage return or line feed or line break”

RW9 — Mon, 07 Nov 2016 15:55:28 GMT

What is the code your using to put data out to DDE? It should be just a matter of sending that special character as well. However I will point out that DDE is well out of date (17years) and is not supported as such any more, so I would really suggest using one of the many other solutions to get data to Excel:
tagsets.excel

libname excel

proc export

CSV

SAS for Office Addin

Etc.

Re: EXCEL dde output containing “CR carriage return or line feed or line break”

t_ar_taat — Tue, 08 Nov 2016 15:32:52 GMT

HI,RW9

Thank you for your comment.

Yes,actually "DDE" is old.I should get away from DDE.

By the way I just find out hint in stackoverflow.

https://stackoverflow.com/questions/32194947/sas-dde-write-multiple-line-in-cell

Re: EXCEL dde output containing “CR carriage return or line feed or line break”

t_ar_taat — Sun, 13 Nov 2016 09:40:14 GMT

It partly depend on EXCEL's Formatting of cell,

var= '"' || "a" || '0a'x || "b" || '"';

put var;