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>
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
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
Could someone give me any advice? Thanks!