Date: Fri, 7 Jan 2005 16:41:22 -0500
Reply-To: Louise Hadden <louise_hadden@ABTASSOC.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Louise Hadden <louise_hadden@ABTASSOC.COM>
Subject: Odd Date Time Field Input
I am working with a very large comma delimited file (over 7G) with one
field toward the end of the record that is a non-standard date time field
that has a blank in the middle of it but not surrounded by double quotes.
Other character values are surrounded by double quotes. Reading with DSD
does not allow a correct read of this field either as character or
numeric. I'm also having trouble trying just using delimiter=','. Has
anyone encountered something similar? Any ideas? Thanks in advance.
The date is in the format 10-10-2003 00:00:00. I'm using 8.2 on AIX UNIX.