Date:         Thu, 15 May 2008 22:48:02 -0400
Reply-To:     Jake Bee <johbee@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jake Bee <johbee@GMAIL.COM>
Subject:      How to have SAS put out a string with blanks in single cells in
              Excel
Content-Type: text/plain; charset=ISO-8859-1

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;