Prev: ODS CSV
Next: Does the R “statistical language
From: Joe Matise on 16 Feb 2010 10:08
How can you differentiate DDMMYY from MMDDYY? You'll need some way to do
so. Clearly when it's >12/<12/xxxx vs <12/>12/xxxx it is not a problem, but
when it is <12/<12/xxxx you will either have to pick a default [or go with
your system default] or preferably have a way to tell which it ought to be.
Does your data come from different sources, for example, that might indicate
which it is [say, one source is DDMMYY and one is MMDDYY]? Do you have some
other date field that is reliable and can be used to give a realistic check
to this one [say, if loan origination date is always mm/dd/yy, and is
5/15/2009, then if the loan amendment date is either 6/3/2009 or 3/6/2009
it's probably fairly easy to tell which is which.

-Joe

On Tue, Feb 16, 2010 at 7:12 AM, ChrisG <chris.godlewski(a)gmail.com> wrote:

> Dear all
>
> I have a dataset with different events regarding loan amendments: loan
> identifier, action type, and some dates !
> These dates are in one column (let say event_date) but unfortunately
> with different formats, i.e. sometimes it is mmddyy10 and sometimes
> ddmmyy10...
> like this :
>
> 05/26/2003
> 05/26/2003
> 05/26/2003
> 02/25/2003
> 04/12/2003
> 10/12/2001
> 10/02/2001
>
> so when i import this stuff in SAS i have serious problems (i get .
> where the format is ddmmyy10 for instance)
> I went through the forum but didn't find anything helpful for my case
> Did anyone face such a situation ?
> Thank you very much for any help !
> Best
> CG
>
 | 
Pages: 1
Prev: ODS CSV
Next: Does the R “statistical language