topic DDE Put is truncating once reaching spaces in Microsoft Integration with SAS

DDE Put is truncating once reaching spaces

deleted_user — Wed, 17 Nov 2010 16:00:30 GMT

I am trying to write a sentence including a macro variable and a statistic (col1 in my data) but the sentence is truncated after the first space. ("Form" is just printed)

filename &myfile. dde "excel|T1!r&rstart.c1:r&rstart.c1";
data _null_;
file &myfile.;
set t1_R1;
put "Form &frm." ; /* actually want "'Form &frm. (N=' col1 ')'"*/
run;

I'm new to DDE (well SAS actually) and am not sure how to avoid this problem.
There are no issues when I print col1 or &frm. without spaces.
Ideas?

Re: DDE Put is truncating once reaching spaces

Oleg_L — Thu, 18 Nov 2010 05:57:09 GMT

Greetings.

Try notab option.

[pre]
FILENAME rr DDE "EXCEL|Sheet1!R2C1:R3C2" notab ;
%let t=Some string of text;
data _NULL_;
file rr;
put "&t";
run;
[/pre]

Oleg. Message was edited by: Oleg_L

Re: DDE Put is truncating once reaching spaces

deleted_user — Fri, 19 Nov 2010 18:37:05 GMT

Thanks so much Oleg! My outputs are perfect now 🙂