I have found it very frustrating to post a comment, ask a question or to reply to a question someone has asked. That being the case, I am asking my question here and hope that you do not get upset.

In my business, we get Excel data that is supposed to be a date in a particular format. However, the data comes to us in all forms. For example, 01-12-01 could mean 1 Dec, 2001, or 12 Jan, 2001. Sometimes the incoming data can be as 010101! SAS will read this data into a dataset based upon an input format. If I specify the date to be dd-mmm-yyyy, it will read at least some of the data incorrectly.

Does anyone have any thoughts on how I can do some SAS magic and interpret all such anomolies as DDMMMYYYY, as SAS likes a DATE?