LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2005, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.

PS.

The date is in the format 10-10-2003 00:00:00. I'm using 8.2 on AIX UNIX.


Back to: Top of message | Previous page | Main SAS-L page