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>
Subject: How to read a excel cell to SAS via DDE when a cell contain '0A'x
Content-Type: text/plain; charset=ISO-8859-1
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?