I imported 5 excel files into SAS and there are some dates formatted as 8/3/1989 originally and formatted into 03Aug1989 (DATE9.) which is what I really want. However, on 1 file the dates failed to converted into DATE9. and it is read as $CHAR10 when I read the log. I tried several ways to reformat it into DATE9 but failed.
- I tried to change all informat/format/input into DATE9. instead of $CHAR10 but failed, the results are all empty (.)
- I tried DateNew=input (Date,DATE9.); but it didn't work either.
Any comment?
Thanks!