Date:         Tue, 6 Jan 2004 10:45:30 -0800
Reply-To:     Helen <sunchunkui@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Helen <sunchunkui@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      How to read a excel cell to SAS via DDE when a cell contain '0A'x
              character?
Content-Type: text/plain; charset=ISO-8859-1

Dear SAS-l,

I am trying to import some worksheets of a workbook into SAS via DDE.
In some cells (e.g. row1 usually take as variable names), there are
'0A'x special charater(Alt+Enter)(e.g. Patient '0a'x Initials) in one
cell. when I use

  INFILE MYEXCEL DSD DLM='09'X NOTAB;

to read, "Patient was in one record, Initial" was in the next one
because SAS take 'oa'x character as dilimiter character too.

I have donzens of worksheets had this kind of cells and I don't want
to remove it manually. I know PROC IMPORT can do it correctly. But I
have many other stuff to do which Proc Import can't. Is there a way to
import it correctly via DDE?

Thanks!

Helen