| Date: | Fri, 10 Jun 2005 15:28:51 -0400 |
|---|
| Reply-To: | Arthur Tabachneck <art297@NETSCAPE.NET> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Arthur Tabachneck <art297@NETSCAPE.NET> |
|---|
| Subject: | Re: carriage return in Excel |
|---|
|
Xiao,
If you can use Proc Import instead, it replaces column name carriage
returns with underscores, and keeps "0A" hex characters within their
intended cells.
Art
----------
On Fri, 10 Jun 2005 14:12:11 -0400, Xiao QT <xiaoqt008@YAHOO.COM> wrote:
>Dear all,
>
>When people hits alt+enter to go to next line in a cell of Excel, it
>inserts a carriage return in that scell. So, when I try to read in that
>excel sheet using DDE, SAS goes to a new line when ever there is a
carriage
>return. I tried DLM='0D'x and it was not working.
>
>Any suggestions?
|
