Date:         Fri, 2 Jan 2004 13:17:43 -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 tell data type and width of columns of excel file via DDE
              when import to SAS?
Content-Type: text/plain; charset=ISO-8859-1

Dear SAS-L,

I am trying to import excel file (one workbook with multipul
worksheets) to SAS via DDE. I would like to know the type of every
column of excel file(e.g. character,numeric, date and datetime) so I
can define them in my SAS dataset. It seems that get.cell(7) function
can do a little. But I am not quite sure especially when one column
only contains numbers but get.cell(7) return 'general' (I take it as
characters type).

Could someone give me any advice?  Thanks!

Helen