Date:         Fri, 25 Jul 2008 14:13:41 -0700
Reply-To:     jliu1971@YAHOO.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         jliu1971@YAHOO.COM
Organization: http://groups.google.com
Subject:      Line break in Excel DDE
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I need to put three lines of info into one cell in Excel.  But the
lines are not wrapped at the right place.  Could someone tell me what
should be the proper delimiter?

I have tried a couple of things but none worked:

data one;
name="John Doe";
age="30";
weight="300";
ostring="John Doe"||" chr(10) "||"30"||" chr(10) "||"300";
output;
run;

data _null_;
file myExcel;
put ostring ;
run;

and also

data _null_;
file myExcel;
put  name '10'x age '10'x weight '10'x ;
run;

Thanks in advance,
Jenni