12-09-2011 07:50 AM
I have a text variable containg dates in the format:
I'm trying to convert these to SAS dates using input statement but get invalid data message for the INPUT statement
Any help on how to get this working
12-09-2011 10:12 AM
I do not know of a format, but you can write a function to make a SAS date value out of the string, see sample below:
12-12-2011 08:55 AM
Not a lot to look up on it (http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002605538.htm), but the anydtdte informat appears to be able to read dates that give all of the other date informats problems. A useful system option to supplement it is the:
in order to guide the informat regarding the order of the three date parts.
Need further help from the community? Please ask a new question.