Help with date formats

[timmy94]

I am trying to convert a date currently in character form to correct format, but my code is changing the date. Could anyone please point out what I am doing wrong?

mthyr_birth (existing data)

Jun2001

Feb1954

Feb1984

My code:

data want;

set have;

mthyr_birth2 = input(mthyr_birth, MONYY.);

format mthyr_birth2 MONYY.;

run;

mthyr_birth2 (output)

JUN20

FEB19

FEB19

Many thanks

[Astounding · Accepted solution]

By default, the MONYY uses a width of 5.  So the INPUT function is reading only 5 characters.  Your data has 7 characters in it, so change MONYY to MONYY7 and you should see better results.

[timmy94]

Thanks so much! 🙂