|Date: ||Wed, 12 May 2010 10:58:24 -0500|
|Reply-To: ||"Data _null_;" <iebupdte@GMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Data _null_;" <iebupdte@GMAIL.COM>|
|Subject: ||Re: Data import from Excel|
|Content-Type: ||text/plain; charset=ISO-8859-1|
Does EXCEL really think the field is a date? That is has EXCEL
converted the value to "excel date"?
On 5/12/10, Mark S. <firstname.lastname@example.org> wrote:
> Every so often I encounter a problem reading in a date field from Excel into
> SAS using proc import, in that it makes the date a character field. The
> problem is solved by going through each cell of the date field in the Excel
> file and both adding then immediately removing a manufactured blank space.
> After this is done for all cells in the field, I can read it into SAS OK as
> numeric. Note that there are no blank spaces in the field initially that are
> the cause of the problem, and this is not the result of guessingrows or other
> option being necessary. Any ideas what the cause might be and a quicker
> solution? THanks!