Dear SAS-L:

Is the a way to have SAS put out strings with spaces in single cells? I tried using '09'x and lrecl=6 in the code below.

The code below creates 6 columns in excel. I only want 2 columns (regardless of the r1c6 endpoint). The 2 columns

should have 'a b c' in c1 and 'l t jb' in c2. Can this be done in SAS to excel via DDE. Thanks for any information!

Jake

%let file_var1 = d:\bee\spreadsheets\[test.xls]sheet1!r1c1:r1c6;

filename out dde "excel|&file_var1";

data a;

length x1-x2 $6;

x1='a b c';

x2='l t jb';

run;

data _null_;

set a;

array x(2)

x1 - x2;

file out;

do i = 1 to 2;

put x(i)@;

end;

put;

run;