DATA Step, Macro, Functions and more

Date Informat Help

Reply
Contributor
Posts: 61

Date Informat Help

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.
Valued Guide
Posts: 2,177

Re: Date Informat Help

have a look at informat YYMMDD
Super Contributor
Posts: 359

Re: Date Informat Help

try anydtdte10. informat.
Super Contributor
Posts: 474

Re: Date Informat Help

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
Ask a Question
Discussion stats
  • 3 replies
  • 139 views
  • 0 likes
  • 4 in conversation