Date Informat Help

[chandler]

This is what the data looks like in my first column called DATE: "2009-11-09". I have the informat set at 10. I've tried SAS informats mmddyy10. and others and it still gives me invalid data warning.

[Peter_C]

have a look at informat YYMMDD

[Flip]

try anydtdte10. informat.

[DanielSantos]

Hi.

Assuming '2009-11-09' represents Day=09 Month=11 and Year=2009

mmddyy10. is precisely the opposite, and would only work for '11-09-2009'.

Since your date is reversed, you should try yymmdd10. instead.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt